Systems and methods of using an artificially intelligent database management system and interfaces for mobile, embedded, and other computing devices

ABSTRACT

The current disclosure generally relates to database management systems (DBMSs) and may be generally directed to methods and systems of using artificial intelligence (i.e. machine learning and/or anticipation functionalities, etc.) to learn a user&#39;s use of a DBMS, store this “knowledge” in a knowledgebase, and anticipate the user&#39;s future operating intentions. The current disclosure may also be generally directed to associative methods and systems of constructing DBMS commands. The current disclosure may also be generally directed to methods and systems of using a simplified DBMS command language (SDCL) for associative DBMS command construction. The current disclosure may also be generally directed to artificially intelligent methods and systems for associative DBMS command construction. The current disclosure may also be generally directed to methods and systems for associative DBMS command construction through voice input. Other methods, systems, features, elements and/or their embodiments are also disclosed.

FIELD OF THE INVENTION

The current disclosure generally relates to database management systems.More specifically, the present disclosure is generally directed tosystems and methods for database management systems and theirapplications on mobile, embedded, and other computing devices andapplications.

BACKGROUND

As processing power and memory become more affordable and compact,mobile, embedded, and other computing devices are being designed toinclude greater functionality. For instance, today's mobile, embedded,and other computing devices such as cellular-enabled computing devices(i.e. Smartphones, etc.) may comprise various applications for the usersin addition to the basic telephonic functionality.

On the other hand, database management systems (DBMSs) are often used onconventional systems for storing, managing and/or manipulatingstructured data by inputting often complicated, complex and lengthy DBMSrelated instructions to be executed by the DBMS to perform operations ondata stored in databases or on databases themselves. As such, operatingthe DBMS may often be a time consuming task, reserved for expensive andwell-trained DBMS operators, thereby also incurring additional cost inorder to perform operations on the data.

SUMMARY OF THE INVENTION

As DBMSs are traditionally reserved for execution on conventionaldatabase servers, personal desktop computers, or other more traditionalcomputing devices, most DBMS management platforms count on the user tobe very well versed in DBMS operation and commands in addition to havingreadily available a keyboard and a mouse for input, a full size displayfor output, and plentiful processing power with a permanent networkconnection and a plethora of bandwidth for operation. Such conditionshowever, should not be assumed for mobile and embedded computing deviceoperations in which a user may not have access to a full size display,mouse or a standard keyboard in order to operate a DBMS. Furthermore, anaverage user of a mobile device may not be highly-trained in DBMSoperation, and yet may need to operate a DBMS or a DBMS application.Therefore, in order to accommodate such a user of a mobile or embeddeddevice to more efficiently and conveniently operate a DBMS via themobile or embedded device platform, new approaches to DBMS design,functioning, and interfacing are herein introduced, enabling the user torealize the benefits of modern DBMS applications, while utilizing a newadvanced DBMS operating functionalities presented below. To that extent,the present disclosure provides solutions to the at least aforementionedissues by providing advanced DBMS application functionalities accessiblevia mobile, embedded, and other computing devices that allow a user toutilize these functionalities on the go.

Concerning the advanced functionalities, the current disclosurediscloses artificial intelligence (i.e. machine learning and/oranticipation functionalities, etc.) to learn the user's use of the DBMS,store this “knowledge” in a knowledgebase, and anticipate the user'sfuture operating intentions with minimal or no user input. With respectto user interfacing, the current disclosure discloses an associativemethod of constructing DBMS commands, a simplified DBMS command language(SDCL) for associative DBMS command construction, and an artificiallyintelligent method for associative DBMS command construction. Also, thecurrent disclosure discloses a method for associative DBMS commandconstruction through voice input.

In one aspect, the present disclosure relates to an interface for anartificially intelligent database management system. In someembodiments, an interface of a database management system may beoperating on a mobile device. The interface may be configured to receivea sequence of instruction sets. Each instruction set may be forperforming an operation on data stored in a database. The sequence ofinstruction sets may comprise a first instruction set followed by asecond instruction set. The interface may disassemble the firstinstruction set into a first plurality of portions and the secondinstruction set into a second plurality of portions. The interface mayperform one or more database operations corresponding to the firstinstruction set followed by the operations corresponding to the secondinstruction set. The interface may receive a new instruction set forperforming an operation on data stored in a database. The interface maydisassemble the new instruction set into a new plurality of portions forcomparing the new plurality of portions with the first plurality ofportions and the second plurality of portions. The interface may alsoselect to display on the mobile device the second instruction set, as anoption to be selected by a user, responsive to a determination that theportions of the new instruction set substantially match the portions ofthe first instruction set and that the second instruction set follows insequence the first instruction set.

In another aspect, the present disclosure relates to a system accessedfrom a mobile device. The system may include a database managementsystem (DBMS) configured to store a sequence of instruction sets, whereeach instruction set is for performing an operation on data stored in adatabase, and the sequence of instruction sets comprises a firstinstruction set followed by a second instruction set, and the firstinstruction set comprises a first plurality of portions and the secondinstruction set comprises the second plurality of portions. The DBMS mayalso be configured to receive a new instruction set for performing anoperation on a database and to disassemble the new instruction set intoa new plurality of portions for comparing the new plurality of portionswith the first plurality of portions and the second plurality ofportions. The DBMS may also be configured to compare one or more of thenew plurality of portions of the new instruction set with one or more ofthe first plurality of portions of the first instruction set. The DBMSmay further be configured to transmit to the mobile device a secondinstruction set, as an option to be selected by a user, responsive to adetermination that the portions of the new instruction set substantiallymatch the portions of the first instruction set and that the secondinstruction set follows in sequence the first instruction set.

In one aspect, the present disclosure relates to an interface for adatabase management system (DBMS). In some embodiments, an interface ofa database management system may be operating on a mobile device. Theinterface may be configured to receive, from the DBMS, a plurality ofcollections of instruction set portions for assembling instruction setsfor performing operations on a database. The interface may associateeach of a plurality of keys of a mobile device with each of a pluralityof instruction set portions from a first collection from the pluralityof collections. The interface may display on the mobile device, for aselection by a user, the plurality of instruction set portions from thefirst collection. The interface may receive, from a database managementsystem (DBMS), a first portion of a new instruction set assembled usinga first instruction set portion from the plurality of instruction setportions from the first collection, the first instruction set portionselected by the user. The interface may re-associate each of theplurality of keys of the mobile device with each of a plurality ofinstruction set portions from a second collection from the plurality ofcollections. The interface may display on the mobile device, for aselection by the user, the plurality of instruction set portions fromthe second collection. The interface may receive, from the DBMS, asecond portion of the new instruction set, the second portion assembledto follow the first portion of the new instruction set, the secondportion of the new instruction set assembled using a second instructionset portion from the plurality of instruction set portions from thesecond collection, the second instruction set portion selected by theuser. The interface may re-associate each of the plurality of keys ofthe mobile device with each of a plurality of instruction set portionsfrom a third collection from the plurality of collections. The interfacemay display on the mobile device, for a selection by the user, theplurality of instruction set portions from the third collection. Theinterface may receive, from the DBMS, a third portion of the newinstruction set, the third portion assembled to follow the secondportion of the new instruction set, the third portion of the newinstruction set assembled using a third instruction set portion from theplurality of instruction set portions from the third collection, thethird instruction set portion selected by the user.

In another aspect, the present disclosure relates to a system accessedfrom a mobile device. The system may include a database managementsystem (DBMS) configured to maintain a plurality of collections ofinstruction set portions for assembling instruction sets for performingoperations on a database. The DBMS may also be configured to assemble,by the DBMS, a first portion of a new instruction set using a firstinstruction set portion from a plurality of instruction set portionsfrom a first collection, the first instruction set portion selected viaa mobile device key associated with the first instruction set portion.The DBMS may also be configured to assemble, by the DBMS, a secondportion of the new instruction set using a second instruction setportion from a plurality of instruction set portions from a secondcollection, the second instruction set portion selected via a mobiledevice key associated with the second instruction set portion, thesecond portion of the new instruction set following the first portion ofthe new instruction set. The DBMS may further be configured to assemble,by the DBMS, a third portion of the new instruction set using a thirdinstruction set portion from a plurality of instruction set portionsfrom a third collection, the third instruction set portion selected viaa mobile device key associated with the third instruction set portion,the third portion of the new instruction set following the secondportion of the new instruction set.

In one aspect, the present disclosure relates to an interface for adatabase management system. In some embodiments, an interface of adatabase management system may be operating on a mobile device. Theinterface may be configured to receive, from the DBMS, a plurality ofcollections of instruction set portions for assembling instruction setsfor performing operations on a database. The interface may associateeach of a plurality of user phrases with each of a plurality ofinstruction set portions from a first collection from the plurality ofcollections. The interface may display on the mobile device, for aselection by a user, the plurality of instruction set portions from thefirst collection. The interface may receive, from a database managementsystem (DBMS), a first portion of a new instruction set assembled usinga first instruction set portion from the plurality of instruction setportions from the first collection, the first instruction set portionselected by the user. The interface may re-associate each of theplurality of user phrases with each of a plurality of instruction setportions from a second collection from the plurality of collections. Theinterface may display on the mobile device, for a selection by the user,the plurality of instruction set portions from the second collection.The interface may receive, from the DBMS, a second portion of the newinstruction set, the second portion assembled to follow the firstportion of the new instruction set, the second portion of the newinstruction set assembled using a second instruction set portion fromthe plurality of instruction set portions from the second collection,the second instruction set portion selected by the user. The interfacemay re-associate each of the plurality of user phrases with each of aplurality of instruction set portions from a third collection from theplurality of collections. The interface may display on the mobiledevice, for a selection by the user, the plurality of instruction setportions from the third collection. The interface may receive, from theDBMS, a third portion of the new instruction set, the third portionassembled to follow the second portion of the new instruction set, thethird portion of the new instruction set assembled using a thirdinstruction set portion from the plurality of instruction set portionsfrom the third collection, the third instruction set portion selected bythe user.

In another aspect, the present disclosure relates to a system accessedfrom a mobile device. The system may include a database managementsystem (DBMS) configured to maintain a plurality of collections ofinstruction set portions for assembling instruction sets for performingoperations on a database. The DBMS may also be configured to assemble,by the DBMS, a first portion of a new instruction set using a firstinstruction set portion from a plurality of instruction set portionsfrom a first collection, the first instruction set portion selected on amobile device via a user phrase associated with the first instructionset portion. The DBMS may also be configured to assemble, by the DBMS, asecond portion of the new instruction set using a second instruction setportion from a plurality of instruction set portions from a secondcollection, the second instruction set portion selected on a mobiledevice via a user phrase associated with the second instruction setportion, the second portion of the new instruction set following thefirst portion of the new instruction set. The DBMS may further beconfigured to assemble, by the DBMS, a third portion of the newinstruction set using a third instruction set portion from a pluralityof instruction set portions from a third collection, the thirdinstruction set portion selected on a mobile device via a user phraseassociated with the third instruction set portion, the third portion ofthe new instruction set following the second portion of the newinstruction set.

In one aspect, the present disclosure relates to an interface for anartificially intelligent database management system. In someembodiments, an interface of a database management system may beoperating on a mobile device. The interface may be configured to receivea sequence of instruction set portions of an instruction set forperforming an operation on data stored in a database. The sequence ofinstruction set portions may comprise a first instruction set portionfollowed by a second instruction set portion. The interface may receivea new instruction set portion of a new instruction set for performing anoperation on data stored in a database. The interface may compare thenew instruction set portion with the first instruction set portion andthe second instruction set portion. The interface may also select todisplay on the mobile device the second instruction set portion, as anoption to be selected by a user, responsive to a determination that thenew instruction set portion substantially match the first instructionset portion and that the second instruction set portion follows insequence the first instruction set portion.

In another aspect, the present disclosure relates to a system accessedfrom a mobile device. The system may include a database managementsystem (DBMS) configured to store a sequence of instruction set portionsof an instruction set for performing an operation on data stored in adatabase, and the sequence of instruction set portions comprises a firstinstruction set portion followed by a second instruction set portion.The DBMS may also be configured to receive a new instruction set portionof a new instruction set for performing an operation on a database. TheDBMS may also be configured to compare the new instruction set portionwith the first instruction set portion and the second instruction setportion. The DBMS may further be configured to transmit to the mobiledevice the second instruction set portion, as an option to be selectedby a user, responsive to a determination that the new instruction setportion substantially matches the first instruction set portion and thatthe second instruction set portion follows in sequence the firstinstruction set portion.

In one aspect, the present disclosure relates to an interface for anartificially intelligent database management system. In someembodiments, an interface of a database management system may beoperating on a mobile device. The interface may be configured to receivea first portion of a new instruction set for performing an operation ondata stored in a database and a second portion of the new instructionset for performing the operation on data stored in the database. Theinterface may disassemble the first and the second portions of the newinstruction set for comparing the first and the second portions with astored plurality of instruction sets. The interface may also select todisplay on the mobile device, a third portion of a first instruction setof the stored plurality of instruction sets, responsive to adetermination that the first instruction set includes a first portionthat substantially matches the first portion of the new instruction setand a second portion that substantially matches the second portion ofthe new instruction set. The interface may further be configured toselect to display on the mobile device, the third portion of a firstinstruction set, responsive to a further determination that the thirdportion of the first instruction set follows the first portion of thefirst instruction set and the second portion of the first instructionset.

In another aspect, the present disclosure relates to a system accessedfrom a mobile device. The system may include a database managementsystem (DBMS) configured to store one or more instruction sets, eachinstruction set of the stored one or more instruction sets includinginstructions for an operation to be performed on data stored in one ormore databases. The DBMS may also be configured to receive, from aninterface for the DBMS, a first portion of a new instruction set forperforming an operation on data stored in a database and a secondportion of the new instruction set for performing the operation on datastored in the database. The DBMS may also be configured to compare thefirst and the second portions of the new instruction set withinstruction sets from the one or more stored instruction sets. The DBMSmay further be configured to transmit, to the interface, a third portionof a first instruction set of the stored plurality of instruction setsin response to a determination that the first portion of the firstinstruction set substantially matches the first portion of the newinstruction set and that the second portion of the first instruction setsubstantially matches the second portion of the new instruction set. TheDBMS may further be configured to transmit, to the interface, the thirdportion of a first instruction set, responsive to a furtherdetermination that that the third portion of the first instruction setfollows the first portion of the first instruction set and the secondportion of the first instruction set.

In one aspect, the present disclosure relates to a system forinterfacing with a database management system. The system may include aninterface of a database management system operating on a mobile device.The interface may be configured to receive a first portion of a newinstruction set for performing an operation on data stored in a databaseand a second portion of the new instruction set for performing theoperation on data stored in the database. The interface may also beconfigured to disassemble the first and the second portions of the newinstruction set for comparing the first and the second portions with astored plurality of instruction sets. The interface may further beconfigured to select to display on the mobile device, a firstinstruction set of the stored plurality of instruction sets. Theselection to display on the mobile device of the first instruction setmay be responsive to a determination that the first instruction setincludes portions that substantially match the first and the secondportions of the new instruction set.

In some embodiments, the interface is further configured to select todisplay on the mobile device, a second instruction set of the storedplurality of instruction sets. The second instruction set may beselected to be displayed responsive to a determination that the secondinstruction set includes portions that substantially match the first andthe second portions of the new instruction set. In further embodiments,the interface is also configured to receive a third portion of the newinstruction set for performing the operation on data stored in thedatabase. The interface may also be configured to disassemble the thirdportion of the new instruction set for comparing the first, the secondand the third portions with a stored plurality of instruction sets andto select for display on the mobile device, a third instruction set ofthe stored plurality of instruction sets, responsive to a determinationthat the third instruction set includes portions that substantiallymatch the first, the second and the third portions of the newinstruction set. The interface may also be configured to select todisplay the third instruction set as a preferred option for a user'sselection with respect to the first instruction set and the secondinstruction set.

In some embodiments, the interface is further configured to select todisplay on the mobile device, the first instruction set, responsive toreceiving the determination from the database management system, incertain embodiments, the interface is further configured to select todisplay on the mobile device the first instruction set as an option tobe selected by a user. In some embodiments, the interface is furtherconfigured to transmit the first instruction set for execution by thedatabase management system, responsive to a user's selection of thefirst instruction set. In yet some embodiments, the interface is furtherconfigured to select to display on the mobile device the firstinstruction set prior to receiving, by the interface, a final portion ofthe new instruction set, the final portion following at least the firstand the second portions of the new instruction set. In certainembodiments, the interface is further configured to receive instructionsfor the database management system to operate on data in the database.In further embodiment, the interface is further configured todisassemble the new instruction set into a plurality of portions,including the first portion and the second portion, as the newinstruction set is being received by the interface.

In some embodiments, each of the stored plurality of instruction setsinclude a different set of instructions for operating, by the databasemanagement system, on data stored in one or more databases. In someembodiments, the stored plurality of instruction sets compriseinstruction sets previously entered by one or more users via theinterface, the instruction sets for instructing the database managementsystem to perform operations on data stored in one or more databases. Infurther embodiments, the stored plurality of instruction sets compriseinstruction sets previously entered by a plurality of different usersvia a plurality of interfaces, the instruction sets for instructing thedatabase management system to perform operations on data stored in oneor more databases.

In some embodiments, the operation on data stored in a databasecomprises one of, or a combination of: accessing, modifying, creating ordeleting a database. In some embodiments, the operation on data storedin a database comprises one of, or a combination of: accessing,modifying, creating or deleting a table of a database. In someembodiments, the operation on data stored in a database comprises oneof, or a combination of: accessing, modifying, creating or deleting of arow, column, or cell within a table of a database. In some embodiments,the operation on data stored in a database comprises one of, or acombination of: accessing, modifying, creating or deleting areport/view, relation, user account, and/or other objects in a DBMS.

In some aspects, the present disclosure relates to a non-transitorycomputer readable medium storing a program causing a computer to executean interface for a database management system. The program may comprisean interface for a database management system configured to: receive afirst portion of a new instruction set for performing an operation ondata stored in a database, receive a second portion of the newinstruction set for performing the operation on data stored in thedatabase, disassemble the first and the second portions of the newinstruction set for comparing the first and the second portions with astored plurality of instruction sets, and select to display on themobile device, a first instruction set of the stored plurality ofinstruction sets, responsive to a determination that the firstinstruction set includes portions that substantially match the first andthe second portions of the new instruction set.

In some aspects, the present disclosure relates to a non-transitorycomputer readable medium storing a program causing a computer to executea database management system. The program may comprise a databasemanagement system (DBMS) configured to: store one or more instructionsets, each instruction set of the stored one or more instruction setsincluding instructions for an operation to be performed on data storedin one or more databases, receive, from an interface for the DBMS, afirst portion of a new instruction set for performing an operation ondata stored in a database and a second portion of the new instructionset for performing the operation on data stored in the database, comparethe first and the second portions of the new instruction set withinstruction sets from the one or more stored instruction sets, andtransmit, to the interface, a first instruction set of the storedplurality of instruction sets in response to a determination that thefirst and the second portions of the new instruction set substantiallymatch portions of the first instruction set.

In some aspects, the present disclosure relates to a system accessedfrom a mobile device. The system may include a database managementsystem (DBMS). The DBMS may be configured to store one or moreinstruction sets, each instruction set of the stored one or moreinstruction sets including instructions for an operation to be performedon data stored in one or more databases. The DBMS may be configured toreceive, from an interface for the DBMS, a first portion of a newinstruction set for performing an operation on data stored in a databaseand a second portion of the new instruction set for performing theoperation on data stored in the database. The DBMS may also beconfigured to compare the first and the second portions of the newinstruction set with instruction sets from the one or more storedinstruction sets. The DBMS may further be configured to transmit, to theinterface, a first instruction set of the stored plurality ofinstruction sets in response to a determination that the first and thesecond portions of the new instruction set substantially match portionsof the first instruction set.

In some embodiments, the DBMS is further configured to receive, from theinterface, a third portion of the new instruction set for performing theoperation on data stored in the database. In further embodiments, theDBMS is also configured to compare the first, the second and the thirdportions of the new instruction set with instruction sets from the oneor more stored instruction sets and to transmit to the interface, asecond instruction set of the stored plurality of instruction sets,responsive to a determination that the first, second and third portionsof the new instruction set substantially match portions of the secondinstruction set.

In some embodiments, the DBMS is further configured to store aninstruction set previously entered via the interface as an instructionset of the one or more stored instruction sets. In further embodiments,the DBMS is further configured to execute the first instruction setresponsive to a selection by the user. In some embodiments, the DBMS isfurther configured transmit, to the interface, a second instruction setof the one or more stored instruction sets responsive to a determinationthat the first and the second portions of the new instruction setsubstantially match portions of the second instruction set.

In some embodiments, the DBMS is further configured to transmit, to theinterface, the first instruction set prior to receiving, by theinterface, a final portion of the new instruction set, the final portionfollowing at least the first and the second portions of the newinstruction set. In some embodiments, the one or more stored instructionsets comprise instruction sets previously entered by one or more users,via the interface, to instruct the DBMS to perform operations on one ormore databases. In yet further embodiments, the one or more storedinstruction sets comprise instruction sets previously entered by aplurality of different users via a plurality of interfaces to instructthe DBMS to perform operations on one or more databases.

In still some embodiments, the operation on data stored in the databasecomprises one of or a combination of: accessing, modifying, creating ordeleting of an entry within a table of the database. In furtherembodiments, the operation on data stored in the database comprises oneof: accessing, modifying, creating or deleting a table of the database.In still further embodiments, the operation on data stored in thedatabase comprises one of: accessing, modifying, creating or deletingthe database.

In certain aspects, the present disclosure relates to systems andmethods for using a mobile processing system for anticipatinginstructions of a user for implementation via a DBMS. The systems andmethods may include and utilize an artificially intelligent databasemanagement system (AI DBMS), an interface through which a user can inputAI DBMS operating instructions, a disassembling unit for disassemblingthe AI DBMS operating instructions, and a maintained list of the user'spast operating instructions that includes various past AI DBMSinstructions. The system may structure the user's past AI DBMS operatinginstructions as knowledge of the user's use of the AI DBMS and storethem along with other stored prior AI DBMS operating instructions in aknowledgebase. The system may then anticipate the user's futureoperating intentions based on the knowledgebase, and assemble the AIDBMS operating instructions based on the anticipating.

In some embodiments, the AI DBMS comprises an underlying DBMS throughwhich the user can perform one or more of accessing, managing and/ormanipulating a data. In some embodiments, performing operations on datain a database includes one or more of accessing, managing and/ormanipulating data. For example, accessing, managing and/or manipulatingdata may include one or more of, or a combination of: (1) accessing,creating, altering, and deleting one or more a database within theunderlying DBMS; (2) accessing, creating, altering, and deleting one ormore a table within the one or more database; (3) accessing, creating,altering, deleting, searching, sorting and rearranging one or more acolumn, a row, and a data cell within the one or more table; (4)accessing, creating, altering, and deleting one or more a report/viewwithin the one or more the database; (5) accessing, creating, altering,and deleting one or more a relation among the one or more the tableand/or the report/view; and (6) accessing, creating, altering, anddeleting one or more a user account and its privileges.

In some embodiments, the interface through which a user can input AIDBMS operating instructions includes a means of inputting one or more ofalphanumeric, acoustic, tactile, and visual operating instructions. Infurther embodiments, the AI DBMS operating instructions includes astructured query language (SQL) statement. In some embodiments, thedisassembling of the AI DBMS operating instructions includesdisassembling a structured query language (SQL) statement into itsinstruction set portions, which may also be referred to as theinstruction set portions. In some embodiments, the maintaining a list ofthe user's past operating instructions includes a data structure forstoring a specific number of the user's past operating instructions. Insome embodiments, structuring the user's past AI DBMS operatinginstructions as knowledge of the user's use of the AI DBMS includescreating a knowledge cell (1) in which some of the user's past AI DBMSoperating instructions are copied into the knowledge cell's anticipatoryoperating instructions, and (2) in which some of the user's past AI DBMSoperating instructions are copied into the knowledge cell's comparativeoperating instructions. In some embodiments, the entries in suchknowledge cells may then be used for anticipating instruction sets whichthe user is intending to implement, by comparing the user's recentlyimplemented instruction sets against the stored prior instruction setsfrom the knowledge cells in the knowledgebase. In other embodiments, theentries in such knowledge cells may then be used for anticipating theinstruction set which the user is intending to input, by comparing theinstruction set portions being inputted against the stored priorinstruction sets from the knowledge cells in the knowledgebase. In yetother embodiments, the entries in such knowledge cells may then be usedfor anticipating the instruction set portions which the user isintending to input, by comparing the instruction set portions beinginputted against the stored prior instruction set portions from theknowledge cells in the knowledgebase.

In some embodiments, storing the knowledge of the user's use of the AIDBMS instructions in a knowledgebase includes a data structure forstoring the knowledge cells. The knowledgebase may include local orremote knowledgebases into which the instruction sets can be stored. Insome embodiments, anticipating of the user's operating intentions basedon the knowledgebase information includes performing a substantialsimilarity comparison between the user's recently implemented operatinginstructions and the operating instructions in the knowledgebase. Inother embodiments, anticipating of the user's operating intentions basedon the knowledgebase information includes performing a substantialsimilarity comparison between the user's recently inputted portions ofan operating instruction and the operating instructions in theknowledgebase. In yet other embodiments, anticipating of the user'soperating intentions based on the knowledgebase information includesperforming a substantial similarity comparison between the user'srecently inputted portions of an operating instruction and the portionsof operating instructions in the knowledgebase. In some embodiments, theassembling AI DBMS operating instructions based on the anticipatingincludes assembling a structured query language (SQL) statement from itsinstruction set portions.

In some aspects, the present disclosure relates to a non-transientmachine readable medium that stores executable instructions, theexecutable instructions causing a machine to perform operationscomprising: defining an artificially intelligent database managementsystem (AI DBMS), generating an interface through which a user can inputAI DBMS operating instructions, disassembling the AI DBMS operatinginstructions, maintaining a list of the user's past operatinginstructions, structuring the user's past AI DBMS operating instructionsas knowledge of the user's use of the AI DBMS, storing the knowledge ofthe user's use of the AI DBMS in a knowledgebase, determining the user'sintended AI DBMS operating instructions based on comparing the user'srecent AI DBMS operating instructions and the data stored in theknowledgebase, and assembling the intended AI DBMS operating instructionset based on the comparison.

Other features and advantages of the current disclosure will becomeapparent from the following description, including the claims anddrawings.

BRIEF DESCRIPTION OF THE DRAWINGS

FIG. 1A illustrates a block diagram of an environment or architecture onwhich the features of the present disclosure may be implemented.

FIG. 1B is a diagram showing an embodiment of AI DBMS implemented on aMobile Device 20.

FIG. 2 is a diagram showing an example of interfacing between the CoreProgram 110 and the Underlying DBMS 120.

FIG. 3 is a diagram showing an example of a typical data organization ofthe Underlying DBMS 120.

FIG. 4 is a diagram showing an example of a typical process flow of theUnderlying DBMS 120.

FIG. 5 is a diagram showing an embodiment of DBMS ArtificialIntelligence 130.

FIG. 6 is a diagram showing an embodiment of Command Disassembler 500.

FIG. 7 is a diagram showing an embodiment of Operation/Instruction SetList 510.

FIG. 8 is a diagram showing an embodiment of Knowledge Structuring Unit520.

FIG. 9 is a diagram showing an embodiment of Knowledgebase 530.

FIG. 10 is a diagram showing an embodiment of Decision-making Unit 540.

FIG. 11 is a diagram showing an embodiment of Confirmation Unit 550.

FIG. 12 is a diagram showing an embodiment of Command Assembler 560.

FIG. 13A is a diagram showing an embodiment of DBMS ArtificialIntelligence 130 with User Specific Info 532 and Group Specific info534.

FIG. 13B is a diagram showing an embodiment of AI DBMS with theUnderlying DBMS 120 executing on a remote computing device.

FIG. 14 is a diagram showing an embodiment of AI DBMS with the CoreProgram 110 and the DBMS Artificial Intelligence 130 executing on aremote computing device.

FIG. 15A is a diagram showing an embodiment of AI DBMS configured toinclude Underlying DBMS Functionality 121 in the Core Program 110.

FIG. 15B is a diagram showing an embodiment of AI DBMS configured toinclude DBMS Artificial Intelligence 130 in the Underlying DBMS 120.

FIG. 16 is a diagram showing an embodiment of AI DBMS with globalKnowledgebase 530 residing on a remote computing device.

FIG. 17A is a diagram showing an embodiment of AI DBMS with DBMSArtificial Intelligence 130 residing on a remote computing device.

FIG. 17B illustrates a flow chart diagram of an embodiment of a method1700 implemented by the AI DBMS.

FIG. 18 is a diagram showing an embodiment of AI DBMS with theAssociative DBMS Command Constructor 190.

FIG. 19 is a diagram showing an embodiment of Associative DBMS CommandConstructor 190.

FIG. 20 is a diagram showing an embodiment of Associative Control Unit1900.

FIG. 21 is a diagram showing an embodiment of Key Association Database1910.

FIG. 22 is a diagram showing an example of functioning of the KeyRe-association Unit 1920.

FIG. 23A is a diagram showing an example of functioning of theAssociative Selection Creator 1930.

FIG. 23B illustrates a flow chart diagram of an embodiment of a method6300 implemented by the AI DBMS.

FIG. 24 is a diagram showing an embodiment of AI DBMS with theAssociative Simplified DBMS Command Language (SDCL) Constructor 2400.

FIG. 25 is a diagram showing an embodiment of Associative SDCLConstructor 2400.

FIG. 26A is a diagram showing an embodiment of SDCL Association Database2500.

FIG. 26B illustrates a flow chart diagram of an embodiment of a method2600 implemented by the AI DBMS.

FIG. 27 is a diagram showing an embodiment of AI DBMS with theAssociative SDCL Constructor 2400 and the Speech Recognizer 2700.

FIG. 28 is a diagram showing an embodiment of Associative SDCLConstructor 2400 with the Associative SDCL Artificial Intelligence 2800.

FIG. 29 is a diagram showing an embodiment of Associative SDCLArtificial Intelligence 2800.

FIG. 30 is a diagram showing an embodiment of Phrase/Instruction SetPortion List 2910.

FIG. 31 is a diagram showing an embodiment of Knowledge Structuring Unit2920.

FIG. 32 is a diagram showing an embodiment of Knowledgebase 2930.

FIG. 33 is a diagram showing an embodiment of Decision-making Unit 2940.

FIG. 34A is a diagram showing an embodiment of Confirmation Unit 2950.

FIG. 34B illustrates a flow chart diagram of an embodiment of a method3400 implemented by the AI DBMS.

FIG. 34C illustrates a flow chart diagram of an embodiment of a method7400 implemented by the AI DBMS.

FIG. 35 is a diagram showing an embodiment of AI DBMS implemented on aMedia Player 3500 with an Underlying Media DBMS 3510.

FIG. 36 is a diagram showing an embodiment of AI DBMS implemented on aGPS Receiver 3600 with an Underlying Locations DBMS 3610.

FIG. 37 is a diagram showing an embodiment of AI DBMS implemented on aPersonal Computer 3700 with an Underlying Business Operation DBMS 3710.

Like reference numerals in different figures indicate like elements.Horizontal or vertical “ . . . ” and other such indicia may be used toindicate additional instances of the same type of element. n, m, n+m,n−m or other such indicia may represent any integers or sequentialnumbers that follow the sequence where they are indicated. Any of theseindicia may be used interchangeably according to the context and spaceavailable.

DETAILED DESCRIPTION

The disclosed systems and methods of using an artificially intelligentDBMS and interfaces for mobile, embedded, and other computing devices(both artificially intelligent DBMS and interfaces herein referred toindividually or collectively as AI DBMS 100, AI DBMS or Smart DBMS)includes advanced features and functionalities to enable a user tooperate a DBMS (i.e. perform operations on data, databases, tables,reports, relations, user accounts, and/or other objects or elementswithin a DBMS, etc.) using a mobile, embedded or other computing device.

In some embodiments, AI DBMS may include machine learning functionalityenabling the AI DBMS to “learn” the user's uses of the DBMS and storethis “knowledge” in a knowledgebase for a future operation. Then, usingthis stored “knowledge”, AI DBMS may anticipate the user's futureoperating intentions. These functionalities enable a user to realize thestandard DBMS operations on a mobile, embedded, or other computingdevice as well as greatly extend the standard operations throughenabling artificially intelligent DBMS operations that may requireminimal or no user input.

Referring now to FIG. 1A, an embodiment of a computing device 20, alsoreferred to as the Mobile Device 20, in which the features of thepresent invention may be implemented is illustrated. In brief overview,devices or systems described herein may include functions, algorithms,hardware or software, or a combination thereof that may be implementedor executed on any type and form of computing device, such as acomputer, a mobile device, a server, a video gaming device, a televisiondevice, a GPS receiver, a media player, an embedded device, or any othertype and form of a computing device capable of performing the operationsdescribed herein. FIG. 1A depicts a block diagram of a computing device20 which may include hardware, software or a combination of hardware andsoftware providing the structure on which the embodiments of the presentdisclosure are practiced. Computing device 20 may include a centralprocessing unit, which may also be referred to as a main processor 11,that may include one or more memory ports 10 and one or more inputoutput ports, also referred to I/O ports 15, such as the I/O ports 15Aand 15B. Computing device 20 may further include, a main memory unit 12which may be connected to the remainder of the components of thecomputing device 20 via a bus 5 and/or may be directly connected to themain processor 11 via memory port 10. The computing device 20 of acomputing device may also include a visual display device 21 such as amonitor, projector or glasses, a keyboard 23 and/or a pointing device24, such as a mouse, interfaced with the remainder of the device via anI/O control 22. Each computing device 20 may also include additionaloptional elements, such as one or more input/output devices 13. Mainprocessor 11 may comprise or be interfaced with a cache memory 14.Storage 125 may comprise memory which provides an operating system, alsoreferred to as OS 17, additional software 18 operating on the OS 17 anddata space 19 in which additional data or information may be stored.Alternative memory device 16 may be connected to the remainingcomponents of the computing environment via bus 5. A network interface25 may also be interfaced with the bus 5 and be used to communicate withexternal computing devices via an external network. Any or all of thedescribed elements of the computing device 20 may be directly oroperatively connected with each other or with other additional elementsas depicted on FIG. 1A or using any other connection means known in theart in alternate embodiments.

Main processor 11 includes any logic circuitry that responds to andprocesses instructions fetched from the main memory unit 12. Mainprocessor 11 may also include any combination of hardware and softwarefor implementing and executing logic functions or algorithms. Mainprocessor 11 may include a single core or a multi core processor. Mainprocessor 11 may comprise any functionality for loading an operatingsystem 17 and operating any software 18 thereon. In many embodiments,the central processing unit is provided by a microprocessing or aprocessing unit, such as for example Snapdragon processors produced byQualcomm Inc., processors by Intel Corporation of Mountain View, Calif.,those manufactured by Motorola Corporation of Schaumburg. Ill.; thosemanufactured by Transmeta Corporation of Santa Clara, Calif.; theRS/6000 processor, those manufactured by International Business Machinesof White Plains, N.Y.; those manufactured by Advanced Micro Devices ofSunnyvale, Calif., or any computing unit for performing similarfunctions. The computing device 20 may be based on any of theseprocessors, or any other processor capable of operating as describedherein, whether on a mobile or embedded device or a larger moreconventional machine.

Main memory unit 12 may include one or more memory chips capable ofstoring data and allowing any storage location to be directly accessedby the microprocessor 11, such as Static random access memory (SRAM),Flash memory, Burst SRAM or SynchBurst SRAM (BSRAM), Dynamic randomaccess memory (DRAM), Fast Page Mode DRAM (FPM DRAM), Enhanced DRAM(EDRAM), Extended Data Output RAM (EDO RAM), Extended Data Output DRAM(EDO DRAM), Burst Extended Data Output DRAM (BEDO DRAM), Enhanced DRAM(EDRAM), synchronous DRAM (SDRAM), JEDEC SRAM, PC100 SDRAM, Double DataRate SDRAM (DDR SDRAM), Enhanced SDRAM (ESDRAM), SyncLink DRAM (SLDRAM),Direct Rambus DRAM (DRDRAM), or Ferroelectric RAM (FRAM). The mainmemory 12 may be based on any of the above described memory chips, orany other available memory chips capable of operating as describedherein. In some embodiments, the main processor 11 communicates withmain memory 12 via a system bus 5. In some embodiments of a computingdevice comprising computing device 20, the processor communicatesdirectly with main memory 12 via a memory port 10.

FIG. 1A depicts an embodiment in which the main processor 11communicates directly with cache memory 14 via a connection means, suchas a secondary bus which may also sometimes be referred to as a backsidebus. In other embodiments, main processor 11 communicates with cachememory 14 using the system bus 5. Main memory 12, I/O device 13 or anyother component of the computing device comprising a computing device 20may be connected with any other components of the computing environmentvia similar secondary bus, depending on the design. Cache memory 14however may typically have a faster response time than main memory 12and may include a type of memory which may be considered faster thanmain memory 12, such as for example SRAM, BSRAM, or EDRAM. Cache memorymay include any structure such as multilevel caches. In someembodiments, the main processor 11 communicates with one or more I/Odevices 13 via a local system bus 5. Various busses may be used toconnect the main processor 11 to any of the I/O devices 13, such as aVESA VL bus, an ISA bus, an EISA bus, a MicroChannel Architecture (MCA)bus, a PCI bus, a PCI-X bus, a PCI-Express bus, or a NuBus. Forembodiments in which the I/O device is a video display 21, the mainprocessor 11 may use an Advanced Graphics Port (AGP) to communicate withthe display 21. In some embodiments, main processor 11 communicatesdirectly with I/O device 13 via HyperTransport, Rapid I/O, orInfiniBand. In further embodiments, local busses and directcommunication are mixed. For example, the main processor 11 maycommunicate with I/O device 13 using a local interconnect bus whilecommunicating with I/O device 13 directly. Similar configurations may beused for any other components described herein.

Computing device 20 may further include alternative memory, such as anSD memory slot, a USB memory stick, an optical drive such as a CD-ROMdrive, a CD-R/RW drive, a DVD-ROM drive or a BlueRay disc, a hard-driveor any other device that may include non-volatile memory suitable forstoring data or installing software and programs. Computing device 20may further include a storage device 125 which may include any type andform of non-volatile memory for storing an operating system (OS) whichmay include any type and form of Windows OS, Mac OS, Unix OS, Linux OS,Android OS, iPhone OS, mobile version of Windows OS, or any other OSthat may operate on the computing device 20. Computing device 20 mayalso include software 18 and/or data space 19 for storing additionaldata or information. In some embodiments, an alternative memory 16 maybe used as the storage device 125. Additionally, OS 17 and/or thesoftware 18 may be run from a bootable medium, for example, a flashdrive, a bootable CD, such as KNOPPIX®, a bootable CD for GNU/Linux thatis available as a GNU/Linux distribution from knoppix.net.

Computing device 20 may include a network interface 25 to interface to aLocal Area Network (LAN), Wide Area Network (WAN) or the Internetthrough a variety of connections including, but not limited to, standardtelephone lines, wired or wireless connections, LAN or WAN links (i.e.802,11, T1, T3, 56 kb, X.25), broadband connections (e.g., ISDN, FrameRelay, ATM), or some combination of any or all of the above. Networkinterface 25 may include Bluetooth or WiFi capability. The networkinterface 25 may comprise a built-in network adapter, network interfacecard. PCMCIA network card, card bus network adapter, wireless networkadapter, Bluetooth adapter, USB network adapter, modem or any otherdevice suitable for interfacing the computing device to any type ofnetwork capable of communication and performing the operations describedherein.

Still referring to FIG. 1A, I/O devices 13 may be present in variousshapes and forms in the computing device 20. Input devices may includejoysticks, keyboards, mice, trackpads, touchscreens, trackballs,microphones, drawing tablets, gloves, video game components forinputting video game data or a video camera. Output devices may includevideo displays, touchscreens, speakers, transceivers for sending andreceiving data. I/O devices 13 may be controlled by an I/O control 22.The I/O control 22 may control one or more I/O devices such as akeyboard 23 and a pointing device 24, e.g., a joystick, a mouse or anoptical pen. I/O control 22 may also comprise an interface between anexternal detector, such as a video camera or a microphone and thecomputing device. I/O control 22 may enable any type and form of adetecting device, such as a video camera to be interfaced with othercomponents of the computing device 20. Furthermore, an I/O device 13 mayalso provide storage 125 and/or an alternative memory 16 for thecomputing device. In still other embodiments, the computing device mayprovide USB connections to receive handheld USB storage devices such asthe USB Flash Drive line of devices manufactured by Twintech Industry,Inc, of Los Alamitos, Calif.

In some embodiments, the computing environment may comprise or beconnected to multiple display devices 21. Display devices 21 may each beof the same or different type and/or form. I/O devices 13 and/or the I/Ocontrol 22 may comprise any type and/or form of suitable hardware,software, or combination of hardware and software to support, enable orprovide for the connection and use of multiple display devices 21 ormultiple detection devices.

In one example, computing device includes any type and/or form of videoadapter, video card, driver, and/or library to interface, communicate,connect or otherwise use the display devices 21 or any I/O devices 13such as video camera devices. In one embodiment, a video adapter maycomprise multiple connectors to interface to multiple display devices21. In other embodiments, the computing device may include multiplevideo adapters, with each video adapter connected to one or more of thedisplay devices 21. In some embodiments, any portion of the operatingsystem of the computing device may be configured for using multipledisplays 21. In other embodiments, one or more of the display devices 21may be provided by one or more other computing devices, such ascomputing devices connected to a remote computing device via a network.

In further embodiments, an I/O device 13 may be a bridge between thesystem bus 5 and an external communication bus, such as a USB bus, anApple Desktop Bus, an RS-232 serial connection, a SCSI bus, a FireWirebus, a FireWire 800 bus, an Ethernet bus, an AppleTalk bus, a GigabitEthernet bus, an Asynchronous Transfer Mode bus, a HIPPI bus, a SuperHIPPI bus, a SerialPlus bus, a SCI/LAMP bus, a FibreChannel bus, or aSerial Attached small computer system interface bus.

Computing environment on the computing device 20 may operate under thecontrol of operating systems, which may control scheduling of tasks andaccess to system resources. The computing device may be running anyoperating system including mobile device or desktop machine operatingsystems, including Android OS, iPhone OS, Windows 8 OS, or any otherversion of OS for running a computing device. For example, with respectto operating systems, the computing device 20 may use different releasesof the Unix and Linux operating systems, any version of the Mac OS® forMacintosh computers, any embedded operating system, any real-timeoperating system, any open source operating system, any video gamingoperating system, any proprietary operating system, any operatingsystems for mobile computing devices, or any other operating systemcapable of running on the computing device and performing the operationsdescribed herein. Typical operating systems include: WINDOWS XP, Windows7, Windows 8 all of which are manufactured by Microsoft Corporation ofRedmond, Wash.; MacOS, iPhone OS manufactured by Apple Computer ofCupertino, Calif.; OS/2, manufactured by international Business Machinesof Armonk, N.Y.; and Linux a freely-available operating systemdistributed by Caldera Corp. of Salt Lake City, Utah, or any type and/orform of a Unix operating system, among others. Similarly, any otheroperating systems by Android or Apple, can be utilized, just as those ofthe Microsoft.

In other embodiments, the computing device 20 may have any differentcombination of processors, operating systems, and input/output devicesconsistent with the device's purpose and structure. For example, in oneembodiment the computing device includes a Snapdragon by Qualcomm, Inc.,or Tegra processors by nVidia, or any other mobile device processor or amicroprocessor for a similar application. In this embodiment, thesmartphone device may be operated under the control of the Android,iPhone OS. PalmOS or any other operating system of a similar purpose.The device may then also include a stylus input device as well as afive-way navigator device. In another example, the computing deviceincludes a Wii video game console released by Nintendo Co. operating anes operating system. In this embodiment, the I/O devices may include avideo camera or an infrared camera for recording or tracking movementsof a player or a participant of a Wii video game. Other I/O devices 13may include a joystick, a keyboard or an RF wireless remote controldevice. Similarly, the computing device 20 may be tailored to anyworkstation, mobile or desktop computer, laptop or notebook computer,Smartphone device or tablet, server, handheld computer, gaming device,embedded device, or any other computer or computing product, or othertype and form of computing or telecommunications device and that hassufficient processor power and memory capacity to perform the operationsdescribed herein.

Still referring to FIG. 1A, from a perspective of a general architectureand variations of the underlying operating environment in which thefeatures of the present disclosure may be implemented, the currentdisclosure is not limited to the use with the configurations shown inthe figures or described in the specification, and it may findapplicability in any operating, computing, communication, electronic,and/or processing environment. The environment may include variousdifferent model infrastructures such as web services, distributedcomputing, grid computing, and other infrastructures.

Various implementations of the methods, systems and techniques describedherein can be realized in digital electronic circuitry, integratedcircuitry, specially designed application specific integrated circuits(ASICs), field programmable gate arrays (FPGAs), computer hardware,firmware, software, virtual machines, and/or combinations thereofincluding their structural, logical, and/or physical equivalents. Thevarious implementations can include implementation in one or morecomputer programs that are executable and/or interpretable on aprogrammable system including at least one programmable processor, whichmay be special or general purpose, coupled to receive data andinstructions from, and to transmit data and instructions to, a storagesystem, at least one input device, and at least one output device.

A computer program (also known as program, software, softwareapplication, script or code) includes machine instructions for aprogrammable processor, and can be implemented in a high-levelprocedural and/or object-oriented programming language, and/or in alow-level assembly/machine language. Any language used may be a compiledor an interpreted language. A computer program may be deployed in anyform, including as a stand-alone program or as a module, component,subroutine, or other unit suitable for use in a computing environment. Acomputer program does not necessarily correspond to a file in a filesystem. A program may be stored in a portion of a file that holds otherprograms or data (i.e. one or more scripts stored in a markup languagedocument, etc.), in a single file dedicated to the program in question,or in multiple coordinated files (i.e. files that store one or moremodules, sub programs, or portions of code, etc.). A computer programmay be deployed to be executed on one computer or on multiple computersat one site or distributed across multiple sites and interconnected by acommunication network.

The methods, systems and techniques described herein may include clientsand servers. A client and server are generally remote from each otherand typically interact through a communication network. The relationshipof client and server arises by virtue of computer programs running onthe respective computers and having a client-server relationship to eachother.

A computing device may be embedded in another device such as a tabletcomp er, a mobile telephone, a personal digital assistant (PDA), a mediaplayer, an audio or video player, a Global Positioning System (GPS)receiver, a game console, a portable storage device (i.e. a USB flashdrive, etc.), gateway, a router, a hub, a digital video recorder, aset-top box, an automobile entertainment system, an automobilenavigation system, a television device, a residential gateway, arefrigerator, a washing machine, a factory automation device, anassembly line device, a factory floor monitoring device, to name just afew. The processor and the memory may be supplemented by, orincorporated in, special purpose logic circuitry.

As used herein, the terms machine-readable medium and computer-readablemedium refer to any computer program product, apparatus and/or deviceused to provide machine instructions and/or data to a programmableprocessor, including a machine-readable medium that receives machineinstructions as a machine-readable signal. The term machine-readablesignal refers to any signal used to provide machine instructions and/ordata to a programmable processor. A machine-readable medium may includeboth a volatile and non-volatile medium, a removable and non-removablemedium, a communication medium, and a storage medium. A communicationmedium may include computer readable instructions, data structures,program modules or other data in a modulated data signal such as acarrier wave or other transport mechanism, and may include any otherform of information delivery medium known in the art.

The methods, systems and techniques described herein can be implementedin a computing system that includes a back end component (Le, a dataserver, etc.), or that includes a middleware component (i.e. anapplication server, etc.), or that includes a front end component (i.e.a client computer having a graphical user interface or a web browserthrough which a user can interact with an implementation of the methods,systems and techniques described herein, etc.), or any combination ofsuch back end, middleware, or front end components. The components ofthe system can be interconnected by any form or medium of digital datacommunication (i.e. a communication network, etc.). Examples ofcommunication networks include the Internet, an intranet, an extranet, alocal area network (LAN), a wide area network (WAN), a personal areanetwork (PAN), a home area network (HAN), a campus area network (CAN), ametropolitan area network (MAN), a global area network (GAN), a storagearea network (SAN), virtual network, a virtual private network (VPN),Bluetooth network, a wireless network, a wireless LAN, a radio network,a HomePNA, a power line communication network, a G.hn network, anoptical fiber network, an Ethernet network, an active networkingnetwork, a client-server network, a peer-to-peer network, a bus network,a star network, a ring network, a mesh network, a star-bus network, atree network, a hierarchical topology network, or any type of networkknown in the art.

Any of the files shown in the figures or described in the specificationmay reside in any repository accessible by an implementation of themethods, systems and techniques described herein. In each instance wherea specific file or file type is mentioned, other files, file types orformats may be substituted.

Where a reference to a data structure is used herein, it should beunderstood that any variety of data structures may be used such as, forexample, array, list, linked list, doubly linked list, queue, tree,heap, graph, map, grid, matrix, multi-dimensional matrix, table,database. DBMS, file, and/or any other type or form of a data structure.

Where a reference to a storing data, object, item or any element is usedherein, it should be understood that any data, object, item or elementstored may be a pointer to the data, object, item or any element storedsomewhere else.

Referring to FIG. 1B, an embodiment of a Mobile Device 20 implementingthe AI DBMS is illustrated, User 10 may operate a Mobile Device 20,which Mobile Device 20 may further include Core Program 110, UnderlyingDBMS 120, DBMS Artificial Intelligence 130, the Input interface 140, theKeyboard 150, the Output Interface 160, the Display 170, the Memory 180,and the Physical Storage Medium 181. Other additional elements may beincluded as needed, or some of the disclosed ones may be excluded, or acombination thereof may be utilized in alternate embodiments.

To clarify the context of the embodiment illustrated by FIG. 1B, theUser 10 may utilize AI DBMS on a Mobile Device 20. Mobile Device 20 mayinclude the Core Program 110 that may accept the User's 10 operatinginstructions and may issue corresponding DBMS Commands to access, manageand/or manipulate (i.e. access, store, create, add, delete, modify orrearrange data, databases, tables, reports, relations, user accountsand/or other DBMS objects or elements, etc.) the Underlying DBMS 120.DBMS command may be any instruction set, operation, Structured QueryLanguage (SQL) statement, computer command, instruction, or any othercommand understood by a DBMS, and these terms may be usedinterchangeably herein. Mobile Device 20 may include the Underlying DBMS120 that receives and executes an instruction set and returns executionresults. The User 10 may interact with the Core Program 110 throughinputting operating instructions via Keyboard 150 and Input Interface140 or another input device and its associated interface. User 10 mayalso interact with the Core Program 110 through viewing results viaDisplay 170 and Output Interface 160 or another output device and itsassociated interface. DBMS Artificial Intelligence 130 may provide thefunctionality of “learning” (i.e. recording, etc.) the User's 10 use ofthe Underlying DBMS 120, structuring this use into usable “knowledge,”storing it into a knowledgebase for future use, and anticipating theUser's 10 future operating intentions. Mobile Device 20 may include theMemory 180 as temporary storage and the Physical Storage Medium 181 aspermanent storage.

Mobile Device 20 may be any mobile computer, a mobile phone, aSmartphone (i.e. iPhone, Windows Phone, Blackberry, Android phone,etc.), a tablet, a personal digital assistant (PDA), or another similartype of mobile device capable of implementating the functionalitiesdescribed herein. The main processor 11 of the Mobile Device 20 mayinclude hardware and software for executing instructions and processingdata operatively coupled with aforementioned memory for storing theinstructions and data. The memory may also include applications such asAI DBMS applications and functions discussed herein. The main processor11 of the Mobile Device 20 may also access a computer-readable mediumincluding a volatile and nonvolatile medium, a removable andnon-removable medium, a communication medium, a storage medium, andother similar type of computer-readable medium. The processor may beoperatively coupled with an output device such as a Liquid CrystalDisplay (LCD) to show information to the user. An input device, such asa key pad, keyboard, and/or touch screen may also be operatively coupledwith the processor to enable the user to input instructions. The memorymay store software that can provide functionality when executed by theprocessor. The software may include a user interface that enables a userto interact with the mobile device, and a mobile operating system thatprovides system functionality. A modern mobile operating system combinesthe features of a personal computer operating system with highresolution display, touchscreen, cellular network connectivity,bluetooth, WiFi. GPS, mobile navigation, microphone, camera, videocamera, voice recorder, speech recognition, music player, near fieldcommunication. PDA, and other features and applications. Examples of amobile operating system include iOS, Android, Windows Mobile, BlackBerryOS, Symbian OS, Palm OS, and other mobile operating systems.

Mobile Device 20 may also be, or include, an embedded device, which maybe any device or system with a dedicated function within a larger deviceor system. Embedded systems may range from the simplest ones dedicatedto one task with no user interfaces to complex ones with advanced userinterfaces that resemble modern desktop computer systems. Simpleembedded devices use buttons, light emitting diodes (LEDs), graphic orcharacter LCDs with a simple menu system. More sophisticated devices mayuse a graphical screen with touch sensing or screen-edge buttons wherethe meaning of the buttons may change with the screen. Examples ofdevices that include an embedded device may include a gaming device, amedia player, a digital still or video camera, a pager, a televisiondevice, a set-top box, a personal navigation device, a globalpositioning system (GPS) receiver, a digital watch, a DVD player, aprinter, a microwave oven, a washing machine, a dishwasher, athermostat, a automobile, a factory controller, a telephone, a router, anetwork bridge, or another similar type of embedded device. The embeddeddevice may include one or more elements described in the Mobile Device20 above such as the main processor 11, any of the aforementionedmemory, the network interface 25, computer-readable medium, the outputdevice, the input device, the user interface, the software, theoperating system, etc. Examples of an operating system for the embeddeddevice include MicroC/OS-II, QNX, VxWorks, eCos, TinyOS, WindowsEmbedded, Embedded Linux, and other embedded operating systems.

Other computing device may be any computing device including atraditional computing device with all of its processing, storage,communication, networking, input and output interfacing, and otherfunctionalities. Examples of the traditional computing device mayinclude a personal desktop computer, a server, a mainframe computer, oranother similar type of the traditional computing device. Thetraditional computing device may include one or more elements describedin the Mobile Device 20 above such as the main processor 11, any of theaforementioned memory, the network interface 25, computer-readablemedium, the output device, the input device, the user interface, thesoftware, the operating system, etc. Examples of an operating system fora traditional computing device include Windows, MacOS, Linux, Unix, andother similar operating systems.

AI DBMS, included in the Mobile Device 20, may be any software, hardwareor a combination of software and hardware for providing machinelearning, anticipating, and/or other functionalities described herein.Similarly, AI DBMS may be any hardware, software or a combination ofhardware and software for providing an interface with a DBMS. In someembodiments, AI DBMS may include a software application or a functionacting as an interface between a user and a DBMS. In furtherembodiments, AI DBMS may include a software application or a functionfor an interface with one or more databases, as a part of a general DBMSoperating and providing one or more databases. For example, AI DBMS maybe executed by the processor that may accept a user's instructions,transmit them to the processor for execution, determine, throughprocessing, that the user's intended instruction set for operating aDBMS is a particular instruction set and transmit results back to theuser including the determined particular instruction set to be presentedto the user.

In some embodiments, AI DBMS may be implemented as a Java Micro Edition(ME), Java Standard Edition (SE), or other Java Editions application orprogram. Java ME is specifically designed for mobile and embeddeddevices and provides a robust and flexible environment for applicationswith flexible user interfaces, robust security, built-in networkprotocols, powerful application programming interfaces. DBMSconnectivity and interfacing functionality, file manipulationcapabilities, and support for networked and offline applications.Applications based on Java ME are portable across many devices, yetleverage each device's native capabilities.

In another embodiment, AI DBMS may be a Java SE application as thetraditional computing devices support it, and more mobile and embeddeddevices continue to support it, Java SE supports the feature sets ofmost Smartphones and a broad range of high-end connected devices whilestill fitting within their resource constraints. Java platforms includeone or more basic application programming interfaces (APIs) and virtualmachine features that comprise a runtime environment for softwareapplications. The use of Java platforms may provide core applicationfunctionality for software applications such as AI DBMS that may beexecuted on mobile, embedded, and other computing devices.

AI DBMS may be a software application that includes a Java programwritten for a Java platform, and is an example of an application thatmay execute on a mobile, embedded, and other computing device. A Javaprogram or application may provide a wide range of user-levelfunctionality that may be used in applications such as AI DBMS,including, but not limited to, providing an Internet browser to a user,displaying text and graphics, playing and recording audio media,displaying and recording visual media, communicating with another mobiledevice, and other functionality. AI DBMS is programming language,platform, and operating system independent. Besides the platforms andoperating systems previously described, programming languages additionalto Java, may include C, C++, Cobol, Java Script, Tcl, Visual Basic,Pascal, VB Script, Ped, PHP, and other programming languages orfunctions capable of implementing the functionalities described herein.

In some embodiments, AI DBMS may be implemented as a Xlet within theJava platform. A Xlet is a Java applet or application configured toexecute on a mobile, embedded, and other computing device, that may be apart of the Java TV specification, and may use a Personal Basis Profile(“PBP”) of a Connected Device Configuration (“CDC”) for the Java MEplatform. A Xlet may be managed by a special-purposeapplication-management software built into the mobile, embedded, andother computing device.

Core Program 110 may be any hardware, software or a combination ofhardware and software directing and controlling the flow of instructionsand data among the elements of AI DBMS system, Core Program 110 may bedirectly or operatively coupled with Underlying DBMS 120, DBMSArtificial Intelligence 130, Input Interface 140, Output interface 160,and/or other elements of the AI DBMS system to produce desired results.Core Program 110 may be initiated by the User 10 or it may be initiatedautomatically when the Mobile Device 20 turns on. Core Program 110 mayrun continuously as a deamon or it may run only as long as the User 10needs it.

Core program 110, as shown in an embodiment illustrated in FIG. 2, maybe, directly or operatively, connected to the Underlying DBMS 120through the ODBC/JDBC API 210, the ODBC/JDBC Bridge 220, and/or theNative ODBC/JDBC Driver 230, in one example. The inter-processinteraction may occur on a single mobile, embedded, or other computingdevice, or between two or more mobile, embedded, or other computingdevices over a network. Other elements or types of connections such as aspecialized database interface, a socket, an operating system command, aglobal function, a local function, a direct command, etc. may beincluded, or some of the disclosed ones may be excluded, or acombination thereof may be utilized in alternate implementations of theinteraction between the Core Program 110 and the Underlying DBMS 120.

Upon connecting to the Underlying DBMS 120, the Core Program 110 maytransmit to the Underlying DBMS 120 an instruction set understood by theUnderlying DBMS 120. Subsequently, the Underlying DBMS 120 may performan operation that corresponds to the instruction set and may transmitresults to the Core Program 110 for presentation to the User 10. In thecase that the instruction set used is a SQL statement, it would beplatform-independent and supported by a vast majority of commercial andopen-source DBMSs. It should be clear to one of ordinary skill in theart that the instruction set (i.e. SQL statement, etc.) discussed hereinas an example, may be replaced by any type or form of instruction set orstatement in any other language or script, as needed to conform to agiven DBMS.

Input Interface 140 may comprise any hardware, software or a combinationof hardware and software, and/or it may include functions and algorithmsfor processing input events of the Keyboard 150 or other input devicesfor use by the Core Program 110 or other elements of the currentdisclosure. The Input Interface 140 may be Java keyboard listener,keypad listener, touch screen listener, mouse listener, trackballlistener, any device driver (i.e. audio, video, keyboard, mouse, orother driver), speech recognizer, video recognizer, or any other inputinterface. Input Interface 140 may be or comprise any functionality ofI/O control 22, keyboard 23, and/or I/O device 13.

Keyboard 150 may comprise any hardware, software or a combination ofhardware and software, and/or it may include functions and algorithmsfor inputting letters, numbers and/or symbols into the Mobile Device 20.Keyboard 150 may be suited or specialized for a mobile device, tablet ora Smartphone. Keyboard 150 may be or comprise any functionality ofkeyboard 23, I/O device 13 and/or I/O control 22. In one implementation,Keyboard 150 may be an element of the current disclosure through whichthe User 10 inputs operating instructions by pressing keys or buttons.Other input devices for detecting user input may be utilized in place ofthe Keyboard 150 such as keypad, touch screen, external keyboard, mouse,trackball, microphone, video or still camera, tactile input device, orany other input device.

Output Interface 160 may comprise any hardware, software or acombination of hardware and software, and/or it may include functionsand algorithms for processing output from the Core Program 110 or otherelements of the current disclosure for presentation to a user. In someembodiments, Output interface 160 may include functions and algorithmsfor processing the results from the Core Program 110 for viewing by theUser 10. The Output interface 160 may be a Java graphical userinterface, an acoustical output interface, tactile output interface, anydevice driver (i.e. audio, video, or other driver), or any other outputinterface. Output interface 160 may be or comprise any functionality ofI/O control 22, display devices 21, and/or I/O device 13.

Display 170 may comprise any hardware, software or a combination ofhardware and software, and/or it may include functions and algorithmsfor displaying information to a user. In some embodiments, Display 170may comprise functions and algorithms for showing AI DBMS results to theUser 10. Other output devices for conveying information may be utilizedsuch as a projector, an external monitor, a speaker, tactile outputdevice, or any other output device, Display 170 may be or comprise anyfunctionality of display devices 21, I/O control 22, and/or I/O device13.

Memory 180 may comprise any hardware, software or a combination ofhardware and software, and/or it may include functions and algorithmsfor storing data or information in an electronic format. Memory 180 maybe, or comprise any functionality of storage 125, cache 14, and/or mainmemory 12. In some embodiments, memory 180 may comprise any hardware,software or a combination of hardware and software, and/or it mayinclude functions and algorithms for temporarily storing programs and/ordata currently running on the Mobile Device 20.

Physical storage medium 180 may also comprise any hardware, software ora combination of hardware and software, and/or it may include functionsand algorithms for storing data and information in an electronic format.In one implementation, the Physical Storage Medium 181 may comprise anyhardware, software or a combination of hardware and software, and/or itmay include functions and algorithms for permanently storing the CoreProgram 110, Underlying DBMS 120 data files and any supporting datastructures, and/or other needed items. The Physical Storage Medium 181may be a hard drive, a microSD card, a flash drive, or any other type ofphysical storage medium. Physical storage medium 181 may be or compriseany functionality of storage 125.

Referring to FIG. 3, Underlying DBMS 120 may comprise any hardware,software or a combination of hardware and software, and/or it mayinclude functions and algorithms for storing, managing and/ormanipulating data and/or any supporting data structures (i.e. databases,tables, etc.). Underlying DBMS 120 may comprise software functionalityfor performing operations which a User 10 of the Underlying DBMS 120 maywant to perform.

As shown in an embodiment illustrated in FIG. 3, Underlying DBMS 120 mayinclude data generally organized in Databases 300. The Database 300 maybe a collection of data generally organized in Tables 310. The term“database” when used casually often refers to a DBMS and the data itcontains as well as the supporting data structures such as databases,tables, reports, relations, user accounts and their privileges, etc.Underlying DBMS 120 may be a relational DBMS in which case the Tables310 and/or Reports/Views 350 may be linked and Relations 360 among theTables 310 and/or Reports/Views 350 may be defined. Furthermore,Underlying DBMS 120 may be or include any data structure or system thatmay store any type or form of data on which data operations describedherein may be performed.

Underlying DBMS 120 may include instruction sets in the form ofstructured query language (SQL) capabilities, SQL is a computer languageused to access, manage, and manipulate data in DBMSs, although othersimilar languages having similar capabilities may be utilized as needed.An example of a SQL statement is as follows: “SELECT col1, col2, col3,FROM tbl1, tbl2, tbl3, ORDER BY cal*, col2*, col3*, . . . ”. In this SQLstatement, “col1, col2, col3, . . . ” represents the Columns 320 to beselected, “tbl1, tbl2, tbl3, . . . ” represents the names of Tables 310from which to obtain data, and “col1*, col2*, col3*, . . . ” representsthe Columns 320 by which to sort the resulting Report/View 350.

In some embodiments, User 10 may not need to input instruction sets suchas SQL statements to operate a DBMS. User 10 may utilize softwareapplication with a graphical user interface or program that generatesinstruction sets understood by the Underlying DBMS 120, For example, areport generating program (i.e. Chrystal Reports, etc.) or a visual DBMSapplication (i.e. Microsoft Access, etc.) may provide input fields,selectable lists, drop-down menus, buttons, or other graphical elementsto enable a User 10 to create instruction sets in a point and clickmanner without ever typing SQL code, for example.

The User 10 may access, manage and/or manipulate the Underlying DBMS 120and the Underlying DBMS 120 may store, manage and/or manipulate dataand/or supporting data structures responsive to the User 10. User's 10accessing, managing and/or manipulating and/or Underlying DBMS's 120storing, managing and/or manipulating data and/or supporting datastructures may include (1) storing, accessing, creating, altering,and/or deleting one or more Database 300 within the Underlying DBMS 120;(2) storing, accessing, creating, altering, and/or deleting one or moreTable 310 within the one or more Database 300; (3) storing, accessing,creating, altering, deleting, searching, sorting and/or rearranging oneor more Column 320, Row 330, and/or Data Cell 340 (generally alsoreferred to as data) within the one or more Table 310; (4) storing,accessing, creating, altering, and/or deleting one or more Report/View350 within the one or more Database 300; (5) storing, accessing,creating, altering, and/or deleting one or more Relation 360 among theone or more Table 310 and/or Report/View 350; (6) storing, accessing,creating, altering, and/or deleting one or more User Account 370 and itsprivileges; and (7) other operations.

Referring to FIG. 4, an embodiment of a typical SQL compliant DBMS isillustrated where the Underlying DBMS 120 may include the followingprocess flow elements: the Query Processing 400, which may includePrecompiler 410, Parser 420, and Execution Engine 430. TransactionManagement 440, also included in this implementation, may compriseTransaction Manager 450, and Log Manager 460. Storage Management 470,also included in Underlying DBMS 120 in this implementation, maycomprise Buffer Manager 480 and Storage Manager 490. Any of theaforementioned components may be stored on, or connected to, eitherdirectly or operatively, memory 180 and/or physical storage medium 181.

Precompiler 410: In some embodiments, Precompiler 410 may comprise anyhardware, software or a combination of hardware and software, and/or itmay include functions and algorithms for extracting the relevant SQLstatement(s) or other DBMS command(s) embedded in the Core Program's 110instruction set, or for translating the instruction set intocorresponding SQL statement(s) or other DBMS command(s). The instructionmay come from an API or directly from an application program such as theCore Program 110. The Precompiler 410 may process Core Program's 110instruction set into SQL statement or any other DBMS command format thatthe Underlying DBMS 120 understands.

Parser 420: In some embodiments, Parser 420 may comprise any hardware,software or a combination of hardware and software, and/or it mayinclude functions and algorithms for parsing the SQL statement(s) orother DBMS command(s) that were deciphered from the Core Program's 110instruction set. At this stage, the objective of the Parser 420 may beto create a parse tree structure based on the SQL statement(s) or otherDBMS command(s) so that it may be easily understood by the otherelements later in the Underlying DBMS 120 execution flow.

Execution Engine 430: In some embodiments, Execution Engine 430 maycomprise any hardware, software or a combination of hardware andsoftware, and/or it may include functions and algorithms for executingthe SQL statement(s) or other DBMS command(s) that were deciphered fromthe Core Program's 110 instruction set against a Database 300 and/or anyof its components to perform an operation on a Database 300 and/or anyof its components. For example, this operation may involve (1)accessing, adding, modifying or deleting a Database 300, (2) accessing,adding, modifying or deleting a Table 310, (3) accessing, adding,modifying or deleting any of the Columns 320, Rows 330 or Data Cells 340of the Tables 310 in the Database 300, and/or (4) any other similaroperation normally implemented by a DBMS. When executing SQLstatement(s) or other DBMS command(s), a plurality of lower leveloperations may generally be performed by the Underlying DBMS 120 in apredetermined order including issuing a read or write request to thePhysical Storage Medium 181:

Transaction Manager 450: In some embodiments, Transaction Manager 450may comprise any hardware, software or a combination of hardware andsoftware, and/or it may include functions and algorithms for ensuringthat a transaction is executed properly in accordance with particularrules of the DBMS, SQL and/or any other applicable system rules. Thetransaction is a single unit of work that has one or more SQLstatement(s) or other DBMS command(s) in it, Transaction Manager 450 mayalso include functionality for resolving any deadlock situations thatmay occur during the process, such as for example during a situationwhen two transactions cannot continue because they each have some datathat the other needs to proceed.

Log Manager 460: In some embodiments, Log Manager 460 may comprise anyhardware, software or a combination of hardware and software, and/or itmay include functions and algorithms for logging every operationexecuted by the Underlying DBMS 120. It may do so by storing a log onthe Physical Storage Medium 181.

Buffer Manager 480: In some embodiments, Buffer Manager 480 may compriseany hardware, software or a combination of hardware and software, and/orit may include functions and algorithms for allocating and managing theMemory 180. Buffer Manager 480 may include functionality to allocateresources for accessing, managing and/or manipulating data. BufferManager 480 may take in formatted requests and decide how much Memory180 to allocate per buffer and how many buffers to allocate per request.

Storage Manager 490: In some embodiments, Storage Manager 490 maycomprise any hardware, software or a combination of hardware andsoftware, and/or it may include functions and algorithms for retrievingand storing data in memory. For example, Storage Manager 490 may includefunctionality, at the lowest level, to make requests through theunderlying Physical Storage Medium 181 controller (not shown; i.e. harddisk controller, etc.) or the operating system to retrieve data from orstore data to the Physical Storage Medium 181. The Physical StorageMedium 181 controller may be a device configured to provide an interfacefor retrieving and storing data and any supporting data structures inphysical files.

Other additional elements such as data definition language (DDL)compiler, query preprocessor, security manager, integration manager,query optimizer, recovery manager, concurrency manager, control manager,resource manager, communications manager, lock manager, page and cachemanager, etc. may be included, or some of the disclosed ones may beexcluded, or a combination thereof may be utilized in alternateimplementations of the Underlying DBMS 120. Also, some features may beincluded in alternate implementations of the Underlying DBMS 120 such asmaintaining the integrity and security of stored data, indices thatprovide fast access to data items that hold particular values,statistical data that store statistical information about the data, etc.

The current disclosure is independent of the type of Underlying DBMS 120it uses that may include any DBMS that can be executed on the operatingenvironments previously described such as Advantage Database Server,EffiProz, ElevateDB, Embedded InnoDB, Empress Embedded Database,Extensible Storage Engine, eXtremeDB, Firebird Embedded, HSQLDB,Informix Dynamic Server, InfinityDB, InterBase, ITTIA DB, NexusDB, RaimaDatabase Manager, ScimoreDB, SolidDB, SQLite, SQL Server Compact,Valentina DB, VistaDB, Oracle, Microsoft SQL Server, MySQL, Informix,Sybase, and other DBMSs. Underlying DBMS 120 may also be a singledatabase, multiple databases, a single table, multiple tables, a singlefile, multiple files, a file system, a single data structure, multipledata structures, a data structure system, a single system, multiplesystems, or any other data structure or a combination of theaforementioned data structures for storing, managing and/or manipulatingdigital data.

Referring to FIG. 5, DBMS Artificial Intelligence 130 may comprise anyhardware, software or a combination of hardware and software, and/or itmay include functions and algorithms for “learning” the User's 10 pastoperating instructions and/or anticipating the User's 10 futureoperating intentions. DBMS Artificial intelligence 130 may comprisefunctions and algorithms for determining one or more instruction sets orsequences of instruction sets which the user may be interested inrunning. DBMS Artificial intelligence 130 may also include functions andalgorithms for identifying a particular number of selected instructionsets to be presented to the user as selections of the instruction setsor sequences of instruction sets which the system has determined theuser may want to execute. The particular number of instruction sets tobe presented may vary based on the determinations of the DBMS ArtificialIntelligence 130, or it may alternatively be predetermined. The DBMSArtificial Intelligence 130 may be, directly or operatively, connectedto the Core Program 110 and/or other elements to facilitate the overallsystem operation and implement the functionalities described herein.

DBMS Artificial Intelligence 130 may include a Command Disassembler 500,an Operation List 510, a Knowledge Structuring Unit 520, a Knowledgebase530, a Decision-making Unit 540, a User Confirmation Unit 550, and aCommand Assembler 560. Other additional elements may be included asneeded, or some of the disclosed ones may be excluded, or a combinationthereof may be utilized in alternate embodiments.

Referring to FIG. 6, Command Disassembler 500 may comprise any hardware,software or a combination of hardware and software, and/or it mayinclude functions and algorithms for disassembling an Instruction Set600 into its instruction Set Portions 620 (also referred to as Inst SetPor) or subsets of the Instruction Set 600. Command Disassembler 500 maybe, directly or operatively, connected to the Core Program 110 and theOperation List 510 and/or other elements to facilitate the overallsystem operation and implement the functionalities described herein.

Instruction Set 600 may be a SQL Statement, any DBMS command, anycomputer command, any instruction or instruction set used to access,manage, and/or manipulate (i.e. add, delete, change, etc.) data and thesupporting data structures (i.e. databases, tables, relations, useraccounts, etc.) in the Underlying DBMS 120. Instruction Set 600 may beissued in structured query language (SQL), a language utilized by manystandard DBMSs, or in any programming language understood by theUnderlying DBMS 120, Instruction Set 600 may comprise a number ofcommands, keywords, instructions, operators, variables, values, objects,functions and/or other components for performing a particular operation.

When an Instruction Set 600, such as the one in FIG. 6, is processed byCommand Disassembler 500, the Instruction Set 600 may be divided orsplit into one or more Instruction Set Portions 620, which InstructionSet Portions 620 may then be stored in an Operation 610. The Operation610 may be any data structure (i.e. array, list, linked list, doublylinked list, queue, table, file, etc.) comprising one or more datafields that may store instruction Set Portions 620 of a particularInstruction Set 600. Therefore, an instruction Set 600 may correspond toa particular Operation 610 identified by that particular Instruction Set600, and vice versa. Also, the Instruction Set 600 may be referred to asthe Operation 610, and vice versa, as this Operation 610 may be arepresentation of this particular Instruction Set 600. In effect, aninstruction Set 600 and its corresponding Operation 610 may be logicalequivalents where the Operation 610 may comprise Instruction Set's 600Instruction Set Portions 620 and Extra Info 630 about the InstructionSet 600 and/or other relevant extra info. Therefore, Instruction Set 600and Operation 610 may be used interchangeably herein.

Instruction Set Portions 620 may comprise particular commands, keywords(i.e. “SELECT”, “FROM”, “INSERT”, etc.), instructions, operators (i.e.=, <, >, etc.), variables, values, objects (i.e. table, database,report/view, etc.), functions (i.e. FIRST( ) MIN( ) MAX( ) etc.) and/orother components (some or all of these components may be usedinterchangeably herein) for performing or specifying a particularportion of the Instruction Set 600. For example, an Instruction SetPortion 620 may include a keyword “SELECT” to indicate a type ofoperation to perform. Keywords “FROM” and “WHERE” may also be used tofacilitate the operation and identify the data on which a particularcommand is to be performed. In addition, keywords may include aparticular variable, such as a particular Database 300 name, or aparticular Row 330 or Column 320 within a particular Table 310, or aparticular data stored in a particular location in the Database 300.

Command Disassembler 500 may comprise functions and/or algorithms foridentifying and recognizing specific commands, keywords, instructions,operators, variables, values, objects, functions and/or other componentsincluded within an Instruction Set 600. In some embodiments, thespecific commands, keywords, instructions, operators, variables, values,objects, functions and/or other components may be included in a lexiconstored in a data structure (i.e. a list, array, table, etc.) containingall possible or most used commands, keywords, instructions, operators,variables, values, objects, functions and/or other components that maygenerally be used in SQL or other DBMS language used, and/or the onesthat may specifically be used in the Underlying DBMS 120. This datastructure may be predefined and may change as the objects or otherelements within the Underlying DBMS 120 change. In one example, inresponse to changing the name of a table within a database, the datastructure would update this table's name in itself, so CommandDisassembler 500 may recognize the updated table name as an InstructionSet Portion 620 in its next run. In other embodiments, the datastructure containing the lexicon may be created on fly or as needed bythe AI DBMS system by (1) reading the Underlying DBMS 120 objects orother elements, meta data, data dictionary, and/or (2) including othertypical Instruction Set Portions 620 (i.e. SQL or other languagekeywords, operators, functions, etc.) used in DBMSs.

Still referring to FIG. 6, in one example, the keyword “SELECT” is anInstruction Set Portion 620 of the Instruction Set 600 and therefore itis extracted and stored in a data field of the Operation 610. The nextInstruction Set Portion 620 that is extracted and stored is the “Col1,Col2 . . . ” representing the columns to be selected. The nextInstruction Set Portion 620 that is extracted and stored is the keyword“FROM”. The next instruction Set Portion 620 that is extracted andstored is the “Tbl1, Tbl2 . . . ” representing the names of tables fromwhich to obtain data. The next Instruction Set Portion 620 that isextracted and stored is the keyword “WHERE”. The next instruction SetPortion 620 that is extracted and stored is the “Col1 Operated Val1 ANDCol2 Operator2 Va12 . . . ” representing columns, operators and valuesused in restricting output results. The next Instruction Set Portion 620that is extracted and stored is the keyword “ORDER BY”. The nextInstruction Set Portion 620 that is extracted and stored is the “Col1,Col2 . . . ” representing columns by which to sort the resulting dataset. The next Instruction Set Portion 620 that is extracted and storedis the keyword “GROUP BY”. The next Instruction Set Portion 620 that isextracted and stored in a data field of the Operation 610 is the “Col1,Col2 . . . ” representing columns by which to group the resulting dataset. Other Instruction Set Portions 620 not shown may be utilized inalternate embodiments such as functions including (1) MIN( ), MAX( ),SUM( ), FIRST( ), LAST( ) etc., (2) operators including OR, LESS THAN,GREATER THAN, etc.; (3) objects including databases, relations, useraccounts; privileges, etc., and (4) other Instruction Set Portions 620including all their variations.

Various types of Instruction Sets 600 will have different InstructionSet Portions 620 stored in Operation 610 data fields. For example,INSERT type of Instruction Set 600 would not have “SELECT”, “FROM”,“WHERE”; “ORDER BY”, and “GROUP BY” keywords and their associatedobjects and operators. Instead, INSERT type of Instruction Set 600 wouldhave different keywords, objects and operators such as “INSERT” and“INTO” keywords and their associated objects and operators.

In addition to Instruction Set's 600 Instruction Set Portions 620, extrainformation or Extra Info 630 such as a time stamp may also be stored inthe data fields within the Operation 610. Time stamp of when theinstruction Set 600 is executed may be useful for anticipation of theUser's 10 future operating intentions related to a specific time frame.Other Extra Info 630 may be included in the Operation 610 such as userspecific information, group user information, any context informationsuch as the type of business for which the AI DBMS is used, the type ofcomputing device executing the AI DBMS, the type of user (novice;moderate; skilled, expert) and other context information, version of theUnderlying DBMS 120, etc. to provide as much information as possible forbest anticipation of the User's 10 future operating intentions. Also,Command Disassembler 500 may be more detailed in its disassembling ofthe Instruction Set 600 in which case every keyword, operator; value andother portions of the Instruction Set 600 may be captured and stored asan instruction Set Portion 620 in the Operation 610. In general, whenthe instruction Set 600 is disassembled into its Instruction SetPortions 620 and stored in the Operation 610 it becomes easier tocompare to other Instruction Sets 600 or Operations 610.

Referring to FIG. 7, Operation List/Instruction Set List 510 (alsoreferred to as Operation List 510 or Instruction Set List 510) maycomprise any hardware, software or a combination of hardware andsoftware; and/or it may include functions and algorithms for storing oneor more Operations 610 and/or their corresponding Instruction Sets 600.In some embodiments; Operation List 510 may include any data structure(i.e. array; list, linked list; table, etc.) that may store one or moreOperations 610 and/or their corresponding Instruction Sets 600. TheOperation List 510 may be, directly or operatively, connected to theCommand Disassembler 500; Knowledge Structuring Unit 520, and theDecision-making Unit 540 and/or other elements to facilitate the overallsystem operation and implement the functionalities described herein.

Operation List 510 may receive Operations 610 or Instruction Sets 600from the Command Disassembler 500 and store a number of Operations 610or instruction Sets 600 that were most recently used or implemented bythe system. The number of Operations 610 or Instruction Sets 600 mostrecently used or implemented may vary depending on the embodiments. Forexample, in some embodiments anywhere between 1 and 10000 most recentlyused or implemented Operations 610 or Instruction Sets 600 may bestored. In some embodiments the number of stored Operations 610 orinstruction Sets 600 is between 2 and 10, such as for example 2, 5, 6,or 9. In other embodiments, the number of Operations 610 or instructionSets 600 is between 10 and 50, such as for example 12, 15, 20, 30, 40 or50 Operations 610 or Instruction Sets 600. In further embodiments, thenumber of Operations 610 or instruction Sets 600 stored is between 50and 200, such as for example 50, 70, 80, 100, 130, 180 or 200 Operations610 or Instruction Sets 600. In further embodiments, the number ofOperations 610 or instruction Sets 600 stored is between 200 and 10000,such as for example 500, 1000, 3000, 5000, 8000 or 10000. The number ofOperations 610 or instruction Sets 600 may be any number, even greaterthan 1000. The number of most recently used or implemented Operations610 or Instruction Sets 600 stored may be even greater than 10000, asone of ordinary skill in the art would recognize that the number ofstored Operations 610 or Instruction Sets 600 may be any number that maybe stored in any memory or storage described herein.

In one embodiment, in which the last nine Operations 610 or instructionSets 600 are stored in the Operation List 510, Operations 610 orInstruction Sets 600 may be identified such that the current Operation610 or Instruction Set 600 is identified as Operation n, the most recentOperation 610 or Instruction Set 600 prior to the current may beidentified as Operation n−1, and so on until the least most recentOperation 610 or Instruction Set 600 being stored is labeled asOperation n−8. In such embodiments, each time the Operation List 510receives another new Operation 610 or instruction Set 600 from theCommand Disassembler 500, it may erase the least recent Operation 610 orInstruction Set 600, such as the Operation n−8, and insert the currentOperation 610 or Instruction Set 600 received as Operation n. Naturally,all the most recently used or implemented Operations 610 or InstructionSets 600 that are stored in this list or queue may be shifted by onecount further towards Operation n−8. This way, the system may maintain aqueue of stored most recently used or implemented Operations 610 orInstruction Sets 600, where the queue may include any number of storedOperations 610 or instruction Sets 600 as previously described.

In one example illustrated in FIG. 7, the Operation List 510 mayrepresent a hypothetical situation where the User 10 may create a tableand perform two repetitions of INSERT, UPDATE, DELETE and SELECT typeoperations.

Referring to FIG. 8, Knowledge Structuring Unit 520 may comprise anyhardware, software or a combination of hardware and software, and/or itmay include functions and algorithms for structuring the “knowledge” ofthe User's 10 use of Operations 610 or instruction Sets 600 foranticipating future Operations 610 or Instruction Sets 600. KnowledgeStructuring Unit 520 may include functions and algorithms forstructuring the stored sequence (i.e. Operation List 510) of User's 10Operations 610 or Instruction Sets 600 into usable “knowledge” forfuture anticipating of the User's 10 operating intentions. KnowledgeStructuring Unit 520 may include the functionality to produce anyvariations of Operations 610 or Instruction Sets 600 that may ever beused by a User 10. Knowledge Structuring Unit 520 may be, directly oroperatively, connected to the Operation List 510 and Knowledgebase 530and/or other elements to facilitate the overall system operation andimplement the functionalities described herein.

In some embodiments, Knowledge Structuring Unit 520 may receive thecurrent Operation List 510 and may create a Knowledge Cell 800 bycopying, for example, Operation n from the Operation List 510 intoOperation n+4 of the Knowledge Cell 800, by copying Operation n−1 fromthe Operation List 510 into Operation n+3 of the Knowledge Cell 800, bycopying Operation n−2 from the Operation List 510 into Operation n+2 ofthe Knowledge Cell 800, and so forth. Knowledge Cell 800 may compriseany hardware, software or a combination of hardware and software, and/orit may include functions and algorithms for storing a recorded sequenceof the User's 10 operating instructions (i.e. Operations 610 orInstruction Sets 600). In effect, when a Knowledge Cell 800 is createdit may include any data structure (i.e. array, list, linked list, table,etc.) that may store a recorded sequence of the User's 10 operatinginstructions (i.e. Operations 610 or Instruction Sets 600) where, forexample, Operation n, Operation n−1, Operation n−2, Operation n−3, andOperation n−4 may later be used for comparison with the then User's 10current and recent operating instructions, and Operation n+1, Operationn+2, Operation n+3, and Operation n+4 may later be used for anticipationof the User's 10 future operating intentions (i.e. future Operations 610or Instruction Sets 600), In some embodiments, Operations 610 orinstruction Sets 600 within the Knowledge Cell 800 with an order numbergreater than n may be anticipatory and the rest of the Operations 610 orinstruction Sets 600 may be comparative, although this particular splitmay differ in alternate embodiments. Any number of comparative and anynumber of anticipatory Operations 610 or Instruction Sets 600 may beincluded in a Knowledge Cell 800 and any number of Knowledge Cells 800may be used in the AI DBMS system. In one embodiment, one long KnowledgeCell 800 may be used in which case comparisons of Operations 610 orInstruction Sets 600 may be performed in a traversing pattern asexplained below. Also, as indicated by the up and down vertical dottedarrows, the copying of Operation n from the Operation List 510 into theKnowledge Cell 800 may start at any Operation n+m through Operation n−mof the Knowledge Cell 800. This way, the number of comparative andanticipatory Operations 610 or Instruction Sets 600 may differ and theycan be determined either by the user or the system itself. For example,a Knowledge Cell 800 may include only one anticipatory Operation 610 orInstruction Set 600 in the case where the copying of the Operation List510 into the Knowledge Cell 800 starts with copying Operation n of theOperation List 510 into Operation n+1 of the Knowledge Cell 800. Inanother example, a Knowledge Cell 800 may include four anticipatoryOperations 610 or Instruction Sets 600 in the case where the copying ofthe Operation List 510 into the Knowledge Cell 800 starts with copyingOperation n of the Operation List 510 into Operation n+4 of theKnowledge Cell 800.

Referring to FIG. 9, Knowledgebase 530 may comprise any hardware,software or a combination of hardware and software, and/or it mayinclude functions and algorithms for storing a plurality of Operations610 or Instruction Sets 600. Knowledgebase 530 may include functions andalgorithms for storing a plurality of Operations 610 or instruction Sets600 generally structured into one or more Knowledge Cells 800, althoughOperations 610 or Instruction Sets 600 may be stored directly in theKnowledgebase 530 and need not be structured into or use Knowledge Cells800. Knowledgebase 530 may include the functionality for storingKnowledge Cells 800, or Operations 610 or instruction Sets 600 in aparticular order to enable easier access and usage of stored data.Knowledgebase 530 may also include the functionality for managing and/ormodifying and/or providing Knowledge Cells 800, or Operations 610 orInstruction Sets 600 as necessary, Knowledgebase 530 may comprise thefunctionality to store and manage all the Knowledge Cells 800, orOperations 610 or instruction Sets 600 that were used or implemented byany users in the past. Knowledgebase 530 may store any variations ofKnowledge Cells 800, or Operations 610 or instruction Sets 600 that mayever be used by a user. Knowledgebase 530 may be, directly oroperatively, connected to the Knowledge Structuring Unit 520 and theDecision-making Unit 540 and/or other elements to facilitate the overallsystem operation and implement the functionalities described herein.

As shown in FIG. 9, Knowledgebase 530 may include a table (a verticalrepresentation of records in a table is shown), although, one or moretables, databases, files, or any other data structures or datarepositories may be used. Knowledgebase 530 may include an entire DBMSdedicated to Knowledgebase 530 functionalities in some embodiments. Forexample, in the case of a single table being used as the Knowledgebase530, a Knowledge Cell 800 may be stored within the table where each ofthe Operations 610 or Instruction Sets 600 of the Knowledge Cell 800 maybe a record with a common Knowledge Cell Identifier (ID) 900 thatsignifies its association with its parent Knowledge Cell 800. Eachrecord within the table may contain data fields (i.e. Instruction SetPortions 620) of the corresponding Operation 610 or Instruction Set 600.Later in the process, a simple call to the table to read all recordswith a specific Knowledge Cell ID 900 would reconstruct the KnowledgeCell 800. Knowledgebase 530 may reside within the Underlying DBMS 120 insome embodiments, or it may reside anywhere outside the Underlying DBMS120 in other embodiments.

In some embodiments, Operations 610 or Instruction Sets 600 may bestored directly within the Knowledgebase 530 without using KnowledgeCell 800 as the intermediary data structure. In these embodiments,Operations 610 or instruction Sets 600 may be stored in one or moresequences (i.e. tables, lists, arrays, etc.) of the Knowledgebase 530.Furthermore, comparisons of Operations 610 or Instruction Sets 600 laterdescribed may be performed by traversing the one or more sequences ofOperations 610 or Instruction Sets 600 to find a match. In one example,Knowledgebase 530 may include all of User's 10 Operations 610 orInstruction Sets 600 in a single long sequence (i.e. table, list, array,etc.), or it may record User's 10 Operations 610 or Instruction Sets 600in daily, weekly, monthly, yearly or other periodic sequences (i.e.monthly tables, monthly lists, monthly arrays, etc.) in another example.In the case of a single long sequence, for example, the comparisons ofOperations 610 or Instruction Sets 600 later described would compareOperations 610 or instruction Sets 600 in the current Operation List 510with subsequences of the single long sequence in incremental or othertraversing pattern. The incremental traversing pattern of comparison maystart from one of the ends of the single long sequence and move thecomparison subsequence up or down the list one incremental Operation 610or instruction Set 600 at a time. Other traversing patterns oralgorithms may be employed such as starting from the middle of thesequence and subdividing the resulting sub-sequences in a recursivepattern, or any other traversing pattern or algorithm.

Referring to FIG. 10, the Decision-making Unit 540 may comprise anyhardware, software or a combination of hardware and software, and/or itmay include functions and algorithms for anticipating the User's 10future operating intentions (i.e. future Operations 610 or InstructionSets 600). Decision-making Unit 540 may comprise algorithms, functions,rules and logic to enable the system to determine which Operation 610 orInstruction Set 600 the User 10 may intend or is most likely to use orimplement. Similarly, Decision-making Unit 540 may comprise thefunctionality to determine which Operation 610 or Instruction Set 600the user is second most likely to use or implement, which Operation 610or Instruction Set 600 the user is third most likely to use orimplement, and so on, Furthermore, Decision-making Unit 540 may comprisethe functionality to determine the sequence or order in which the usermay intend or is most likely to use or implement Operations 610 orinstruction Sets 600. The Decision-making Unit 540 may be, directly oroperatively, connected to the Operation List 510 and the Knowledgebase530 and/or other elements to facilitate the overall system operation andimplement the functionalities described herein.

As shown in FIG. 10, Decision-making Unit 540 may anticipate the User's10 future operating intentions (i.e. future Operations 610 orInstruction Sets 600) by performing Substantial Similarity Comparisons1010 between the current Operation List 510 and Knowledge Cells 800stored in the Knowledgebase 530. This may be done by performingSubstantial Similarity Comparisons 1010 one Knowledge Cell 800 at atime, by traversing a one long knowledge cell, or by other similaralgorithms.

Substantial Similarity Comparison 1010 may comprise any hardware,software or a combination of hardware and software, and/or it mayinclude functions and algorithms for comparing or matching Operations610 or Instruction Sets 600, Substantial Similarity Comparison 1010 mayinclude functions and algorithms for comparing or matching Operations610 or Instruction Sets 600 from the Operation List 510 with (1)Operations 610 or Instruction Sets 600 stored in a Knowledgebase 530 or(2) Operations 610 or Instruction Sets 600 from the Knowledge Cells 800stored in a Knowledgebase 530. In some embodiments, the comparing ormatching may include comparing Operations 610 or instruction Sets 600from the Operation List 510 with comparative Operations 610 orinstruction Sets 600 from the Knowledge Cells 800 stored in aKnowledgebase 530. Substantial Similarity Comparison 1010 may comprisealgorithms, functions and/or logic for performing matching orcomparisons and for determining that while a perfect match is not found,a substantially similar match has been found. Substantial SimilarityComparison 1010 may therefore identify an Operation 610 or InstructionSet 600 from an Operation List 510 that is most like an Operation 610 orInstruction Set 600 from a Knowledge Cell 800 in a Knowledgebase 530,even if the Operation 610 or Instruction Set 600 from the Operation List510 is different from the Operation 610 or instruction Set 600 in theKnowledge Cell 800.

In some embodiments such as one illustrated in FIG. 10, SubstantialSimilarity Comparison 1010 may include comparing a particular number ofUser's 10 most recently implemented Operations 610 or Instruction Sets600 (such as for example: Operation n, Operation n−1, Operation n−2,Operation n−3, Operation n−4, etc.) from the Operations List 510 withthe corresponding Operations 610 or Instruction Sets 600 from theKnowledge Cells 800 in the Knowledgebase 530. If a substantially similarpattern of User's 10 most recently implemented Operations 610 orInstruction Sets 600 (such as for example: Operation n, Operation n−1,Operation n−2, Operation n−3, Operation n−4, etc.) is found, subsequentUser's 10 operating intentions (i.e. future Operations 610 orinstruction Sets 600) may be anticipated in the anticipatory Operations610 or instruction Sets 600 (such as for example: Operation n+1,Operation n+2, Operation n+3, Operation n+4, etc.). Any number ofOperations 610 or Instruction Sets 600 may be compared in alternateembodiments of the Substantial Similarity Comparisons 1010.

Still referring to FIG. 10, each Substantial Similarity Comparison 1010may comprise a Comparison Strictness Function 1011. Although FIG. 10illustrates each Substantial Similarity Comparison 1010 including itsown dedicated Comparison Strictness Function 1011, in some embodiments,Comparison Strictness Function 1011 may be a single function, inconnection with a Decision-making Unit 540, servicing multitudeSubstantial Similarity Comparisons 1010. Comparison Strictness Function1011 may comprise hardware, software or a combination of hardware andsoftware for determining the strictness criteria for finding asubstantial similarity match between the Operations 610 or instructionSets 600 in the Operation List 510 and the Knowledgebase 530, Asappropriately strict rules for substantial similarity need to be definedin the Substantial Similarity Comparisons 1010, if the rules are toostrict, the Substantial Similarity Comparisons 1010 may not find amatching Knowledge Cell 800 in the Knowledgebase 530. On the other hand,if the rules are too flexible the Substantial Similarity Comparisons1010 may find too many matching Knowledge Cells 800 and may anticipateinaccurate User's 10 future operating intentions (i.e. future Operations610 or Instruction Sets 600). Comparison Strictness Function 1011 maytherefore include the functionality for setting and resetting thestrictness of rules for finding the substantially similar matches,thereby fine tuning the Substantial Similarity Comparisons 1010 so thatthe rules for finding the match are not too strict nor too lenient.

The appropriately strict rules for substantial similarity may be definedfor the current disclosure based on the type of DBMS application,experience, testing logs, inquiry, analysis, synthesis or othertechniques in alternate implementations. As such, the strictness rulesof the Comparison Strictness Function 1011 may be set by the user or byAI DBMS administrator based on such experience and knowledge. In oneimplementation, substantial similarity may be achieved when most of theInstruction Set Portions 620 of the User's 10 most recently implementedOperations 610 or instruction Sets 600, such as for example fiveOperations 610 or Instruction Sets 600 (i.e. Operation n, Operation n−1,Operation n−2, Operation n−3, and Operation n−4) in the Operations List510 substantially match the Instruction Set Portions 620 of thecorresponding (i.e. comparative) Operations 610 or Instruction Sets 600from a Knowledge Cell 800, Alternatively, total equivalence may be foundwhen all Instruction Set Portions 620 of the User's 10 most recentlyimplemented Operations 610 or instruction Sets 600 from the OperationList 510 match the Instruction Set Portions 620 of all corresponding(i.e. comparative) Operations 610 or Instruction Sets 600 from aKnowledge Cell 800 within the Knowledgebase 530. In other embodiments,when a total equivalence match is not found, Substantial SimilarityComparison 1010 may omit values, operators, or other components from thecomparison, although values, operators, or other components are capturedas sub-segments of Instruction Set Portions 620.

Comparison Strictness Function 1011 may comprise algorithms, functionsand logic to automatically adjust its level of strictness for finding abest substantial similarity match between the Operations 610 orInstruction Sets 600 in the Operation List 510 and the corresponding(i.e. comparative) Operations 610 or instruction Sets 600 in theKnowledgebase 530 (i.e. Knowledge Cells 800 stored in the Knowledgebase530 or Operations 610 or instruction Sets 600 stored in theKnowledgebase 530). Depending on the design, various levels ofstrictness may be used. In some embodiments, Comparison StrictnessFunction 1011 may set the rules to search for a substantial similarityby finding perfect matches between the Operations 610 or InstructionSets 600 in the Operation List 510 and the corresponding (i.e.comparative) Operations 610 or Instruction Sets 600 in the Knowledgebase530. If such a match is not found, Comparison Strictness Function 1011may decrease the strictness level. In some embodiments, in response todecreasing the strictness level, Comparison Strictness Function 1011 mayset the strictness of the rules to search for a substantial similarityin terms of a total equivalence with respect to command portions of theOperation 610 or Instruction Set 600 only, thereby tolerating mismatchesin variable names, such as the names of databases or tables. ComparisonStrictness Function 1011 may choose to relax the rules in response todetermining that no total equivalence match had been found. For example,in such embodiments; a substantial similarity may be achieved when amatch is found in terms of a correct operation, but for a differentdatabase than the one the user wants to operate on. In such instances,upon presenting the user with the substantial similarity match (i.e.substantially similar Knowledge Cell 800), the AI DBMS may give the useran anticipatory Operation 610 or Instruction Set 600 from the matchedKnowledge Cell 800 allowing the user to change the variable names intothe ones desired, still saving the user work on inputting the commands.In further embodiments, Comparison Strictness Function 1011 may, upondetermining that a perfect match is not found, allow for matching allbut one of the Operations 610 or instruction Sets 600 from the OperationList 510 and the corresponding (i.e. comparative) Operations 610 orInstruction Sets 600 in the Knowledgebase 530. In further embodiments,the Comparison Strictness Function 1011 may set the rules to find amatch with all but two or more Operations 610 or Instruction Sets 600from the Operation List 510 and the corresponding (i.e. comparative)Operations 610 or Instruction Sets 600 in the Knowledgebase 530.

All the aforementioned settings of strictness of the substantialsimilarity match may be set, or reset, by the Comparison StrictnessFunction 1011, in response of another strictness level determination.For example, Comparison Strictness Function 1011 may adjust a strictnesslevel for identifying a substantial similarity match for an Operation610 or Instruction Set 600 whose Instruction Set Portions 620corresponding to command words are a total match with Instruction SetPortions 620 of an Operation 610 or Instruction Set 600 in aKnowledgebase 530, while tolerating mismatches in table names, databasenames and similar. Such an adjustment in strictness may be done by theComparison Strictness Function 1011 in response to determining that atotal equivalence match for an entire Operation 610 or Instruction Set600 is not found in the Knowledgebase 530. Similarly, ComparisonStrictness Function 1011 may adjust the strictness level for identifyinga substantial similarity match for an Operation 610 or Instruction Set600 whose instruction Set Portions 620 match all but one instruction SetPortion 620 of an Operation 610 or Instruction Set 600 in aKnowledgebase 530. Also, Comparison Strictness Function 1011 may adjustthe strictness level for identifying a substantial similarity match foran Operation 610 or instruction Set 600 whose Instruction Set Portions620 match all but two or more instruction Set Portions 620 of anOperation 610 or Instruction Set 600 in a Knowledgebase 530. Such anadjustment in strictness may be done by the Comparison StrictnessFunction 1011 in response to determining that not a sufficient number ofmatches had been found using a higher strictness level.

Comparison Strictness Function 1011 may therefore increase and decreasethe strictness of the rules for finding a substantial similarity matchdepending on whether or not perfect matches (i.e. perfect equivalentsbetween the compared Operations 610 or Instruction Sets 600) had beenfound. As such, Comparison Strictness Function 1011 may utilize twothresholds, the upper and a lower threshold, to determine the strictnessof the rules used for determining the substantial similarity match. Theupper threshold may correspond to the number of substantial similaritymatches that are too high to be presented to the user (i.e. too manymatching results, too vague suggestions). Alternatively, the lowerthreshold may correspond to the strictness level that results in too fewresults to be presented to the user. Comparison Strictness Function 1011may make any combination of the aforementioned adjustments to achievethat the number of substantial similarity matches between the Operations610 or Instruction Sets 600 in the Operation List 510 and thecorresponding (i.e. comparative) Operations 610 or Instruction Sets 600in the Knowledgebase 530 falls between the upper and the lowerthreshold. As such, Comparison Strictness Function 1011 may keepadjusting the strictness rules for finding the substantially similarmatch until both thresholds are satisfied, thereby adjusting the resultsuntil the best set of results is found.

In one embodiment, Comparison Strictness Function 1011 may adjust thestrictness level by choosing the number of Operations 610 or instructionSets 600 that it will use to find a substantial similarity match. Forexample, as a user implements first three Operations 610 or InstructionSets 600, Comparison Strictness Function 1011 may run these threeOperations 610 or instruction Sets 600 against Knowledge Cells 800 inthe Knowledgebase 530. If the Substantial Similarity Comparison 1010provides a number of matching results (i.e. results that have perfectequivalence) that is above a particular threshold, the ComparisonStrictness Function 1011 may decide to increase the strictness of therules to decrease the number of results. In response, SubstantialSimilarity Comparison 1010 may then decide to wait for the user to add afourth Operation 610 or Instruction Set 600, thereby allowing theSubstantial Similarity Comparison 1010 to use the fourth Operation 610or Instruction Set 600 in addition to the earlier three to find asmaller number of matching results. Once the user adds the fourthOperation 610 or Instruction Set 600, the Substantial SimilarityComparison 1010 may use all four Operations 610 or Instruction Sets 600to find a match. If the number of matching results (i.e., results thatperfectly match or total equivalences) is sufficiently small, the systemmay present the user with these results. If however, the number ofmatching results is still too high, the Comparison Strictness Function1011 may determine to further increase the strictness by requiring theuser to add additional Operations 610 or Instruction Sets 600 andthereby further narrow the search results before presenting the userwith the suggested results. In some embodiments, Operations 610 orInstruction Sets 600 added may include a portion of an Operation 610 orinstruction Set 600 such as a first one or more Instruction Set Portions620 or one or more letters or one or more keywords, commands, phrases,etc. of such instruction Set Portions 620.

To increase comparison accuracy. Extra info 630 (i.e. time stamp, userspecific information, group user information, etc.) besides InstructionSet Portions 620 may be recorded at the creation of an Operation 610 bythe Command Disassembler 500, as previously described, SubstantialSimilarity Comparison 1010 may use this additional information forfinding the best match between the Operations 610 or Instruction Sets600 in the Operation List 510 and the corresponding (i.e. comparative)Operations 610 or instruction Sets 600 in the Knowledgebase 530.Concerning time stamp. User 10 may perform some operations such as databackup periodically, such as for example, during a specific time of day,week, month, year or any other time period. The Substantial SimilarityComparison 1010 may utilize the time stamp in the comparisons todetermine the best match in the case of these time-sensitive Operations610 or Instruction Sets 600.

Another technique for increasing comparison accuracy and/or adjustingstrictness level of the Comparison Strictness Function 1011 may be toassign an importance index (i.e. on a scale from 1 to 10) to eachInstruction Set Portion 620 and/or Extra info 630. This way, theSubstantial Similarity Comparison 1010 may focus more on the comparisonof, for example, command words, keywords and/or objects, and less onoperators and time stamps for certain types of Operations 610 orInstruction Sets 600.

Another technique for increasing comparison accuracy and/or adjustingstrictness level of the Comparison Strictness Function 1011 may be toinclude semantic analysis in the Substantial Similarity Comparison 1010.For example, an Operation 610 or Instruction Set 600 from the OperationList 510 may contain a table called Customers. Instead of looking forthe exact name match in the corresponding (i.e. comparative) Operation610 or instruction Set 600 from the Knowledgebase 530 the SubstantialSimilarity Comparison 1010 may employ semantic analysis and attempt tomatch Cust, Cst, Cstm, Cstmr, Cstmrs, or other variations of the tablename with a meaning Customers. This semantic analysis method is notlimited to the use only with meanings of object names such as databasenames, table names, column names, etc. This approach may be utilizedwith any differing field or segment of an Operation 610 or InstructionSet 600 with a potentially same meaning such as various operators withsame meanings, various values with same meanings, various keywords withsame meanings, etc.

Another technique that may be used is for the Substantial SimilarityComparison 1010 to assign comparison accuracy (not shown) during thecomparison process based on how well matched are the Operations 610 orInstruction Sets 600 of the Operation List 500 to the Operations 610 orinstruction Sets 600 of a Knowledge Cell 800 in the Knowledgebase 530.An indicator of comparison accuracy with a scale from 1 to 10 may beutilized, for example. The indicator of comparison accuracy may then bestored in the Operations 610 or Instruction Sets 600 of theSubstantially Similar Knowledge Cell 1110. Comparison accuracyinformation may be useful later in the User Confirmation 1130 processstep to help automate the confirmation process.

Referring to FIG. 11, Confirmation Unit 550 may comprise any hardware,software or a combination of hardware and software, and/or it mayinclude functions and algorithms for confirming the User's 10anticipated operating intentions (i.e. anticipatory Operations 610 orInstruction Sets 600) with the User 10. Confirmation Unit 550 maycomprise algorithms and functions to enable the system to confirm theOperations 610 or Instruction Sets 600 that the AI DBMS determined (i.e.via the substantial similarity comparison) could be the Operations 610or Instruction Sets 600 which the user may want to use or implement.Confirmation Unit 550 may be, directly or operatively, connected to theDecision-making Unit 540 and the Command Assembler 560 and/or otherelements to facilitate the overall system operation and implement thefunctionalities described herein.

As shown in FIG. 11, Confirmation Unit 550 may include SubstantiallySimilar Knowledge Cell 1110, Context Interpreter 1120, User Confirmation1130 process step, and Operation List 510. Other additional elements maybe included as needed, or some of the disclosed ones may be excluded, ora combination thereof may be utilized in alternate embodiments. TheSubstantially Similar Knowledge Cell 1110 may be a product of theDecision-making Unit 540 and may be the knowledge cell whose comparativeOperations 610 or Instruction Sets 600 are substantially similar to theUser's 10 most recently implemented Operations 610 or instruction Sets600 from the Operation List 510.

The context in which Operations 610 or Instruction Sets 600 from theOperation List 510 were performed may be analyzed by the ContextInterpreter 1120. In some embodiments, context may be defined as (1) anysegment of the Instruction Set 600 not captured as an Instruction SetPortion 620 in an Operation 610, (2) any sub-segment of an InstructionSet Portion 620 within an Operation 610 that is not used in theSubstantial Similarity Comparison 1010, or (3) any information aboutOperations 610 or instruction Sets 600 from the Operation List 510 thatmay be useful in anticipating User's 10 operating intentions (futureOperations 610 or Instruction Sets 600). In effect, Context Interpreter1120 may perform an extra analysis step and it may attempt to captureall information and/or elements that may have been omitted by theCommand Disassembler 500, by the Substantial Similarity Comparison 1010,or by other process steps.

An example of Context Interpreter's 1120 usefulness is the fact thatvalues may be omitted from Substantial Similarity Comparisons 1010 insome embodiments, as previously described. It is Context Interpreter's1120 responsibility to discover the values or ranges of values used inthe User's recent Operations 610 or Instruction Sets 600 by extractingthe values from their Instruction Set Portions 620. User Confirmation1130 process steps may then take these values or ranges of values,modify anticipatory Operations 610 or Instruction Sets 600 (such as forexample: Operation n+1, Operation n+2, Operation n+3, Operation n+5,etc.) according to these values or ranges of values, and present themodified anticipatory Operations 610 or Instruction Sets 600 to the User10 for confirmation before executing them.

User Confirmation 1130 may comprise any hardware, software or acombination of hardware and software, and/or it may include functionsand algorithms for automating user confirmation if the SubstantiallySimilar Knowledge Cell 1110 contains comparison accuracy information aspreviously described, such as for example an instance in which one ormore comparative Operations 610 or Instruction Sets 600 were found to bea perfect or highly accurate match. In such instances, anticipatoryOperations 610 or Instruction Sets 600 from the Substantially SimilarKnowledge Cell 1110 may be automatically executed by AI DBMS withoutasking the user to confirm them. As such, anticipatory Operations 610 orInstruction Sets 600 from the Substantially Similar Knowledge Cell 1110with complete or high comparison accuracy may be executed without theneed to confirm with User 10. Conversely, anticipatory Operations 610 orinstruction Sets 600 from the Substantially Similar Knowledge Cell 1110with less than high comparison accuracy may be presented to User 10 forconfirmation including presenting the comparison accuracy informationfor User's 10 consideration.

Referring to FIG. 12, Command Assembler 560 may comprise any hardware,software or a combination of hardware and software, and/or it mayinclude functions and algorithms for assembling an instruction Set 600.Command Assembler 560 may include functions and algorithms forassembling an Instruction Set 600 from the Instruction Set Portions 620stored in the Operation 610. Alternatively, when a complete InstructionSet 600 is known and no assembly of various Instruction Set Portions 620is needed, Command Assembler 560 may simply verify that the InstructionSet 600 is ready for implementation by the AI DBMS. Command Assembler560 may be, directly or operatively, connected to Confirmation Unit 550and Core Program 110 and/or other elements to facilitate the overallsystem operation and implement the functionalities described herein.

As shown in FIG. 12, Command Assembler 560 may assemble Instruction Set600 from the Instruction Set Portions 620 stored in the data fields ofthe Operation 610. Command Assembler 560 in effect performs the reverseaction relative to the Command Disassembler 500.

In some embodiments, when anticipatory Operations 610 or instructionSets 600 are known and ready to execute, Command Assembler 560 or anyother element of the current disclosure may trigger an external functionor process of the system within which AI DBMS may operate. For example,in an embodiment where AI DBMS may be used or embedded within atelevision device (embodiment later described), AI DBMS may trigger avideo recording process in response to anticipating a User's 10switching (i.e. selecting or performing a SELECT type DBMS operation) toa favorite channel. In another embodiment where AI DBMS may be used orembedded within a cellular telephone, AI DBMS may trigger a callingprocess in response to anticipating User's 10 input (i.e. inserting orperforming an INSERT type DBMS operation) of a new contact in thecontact list.

In yet some embodiments, an Instruction Set 600 may be passed directlyto the Operation List 510 without being disassembled, in which caseCommand Disassembler 500 may be omitted from the overall system. Inthese embodiments, Operation List 510, Knowledge Cells 800, andKnowledgebase 530 may all include original Instruction Sets 600 insteadof disassembled Operations 610. Therefore, Substantial SimilarityComparisons 1010 between the Instruction Sets 600 in the Operation List510 and the corresponding (i.e. comparative) instruction Sets 600 in theKnowledgebase 530 may be performed either directly (i.e. letter forletter, word for word, etc.) or indirectly by performing extraction ordisassembling of Instruction Set Portions 620 in the comparison step.

In further embodiments, AI DBMS may be configured to run automatically(i.e. autonomously, etc.) and/or perform DBMS operations. For example,AI DBMS and/or Artificial Intelligence 130 may periodically (i.e. daily,weekly, monthly, yearly, etc.) automatically run to analyze (i.e.through the Substantial Similarity Comparison 1010 process, etc.) timestamps of all of the Operations 610 or Instruction Sets 600 in theKnowledgebase 530 to determine which Operations 610 or instruction Sets600 the User 10 may have implemented in particular time periods. Ifrepetitive Operations 610 or Instruction Sets 600 may have been found,they may be executed automatically with or without User's 10confirmation depending, for example, on how accurate or confident thesubstantial similarity match may be. Other patterns in addition toanalyzing the time stamp may be analyzed in alternate embodiments.

Referring to FIG. 13A, in some aspects of the present disclosure, AIDBMS may be implemented to include additional information either withinthe Knowledgebase 530, within additional knowledgebases, or within anyother part of the AI DBMS system. This additional information may assistthe Substantial Similarity Comparison 1010 and/or other process stepsand/or elements in the performance of their respective functions (i.e.more accurately anticipate user's future DBMS operating intentions,etc.). As shown in FIG. 13A, AI DBMS may comprise additionalknowledgebases that, in this example, may include User Specificinformation 532, Group Specific information 534, and/or other additionalknowledgebases. These additional knowledgebases may be directly oroperatively coupled with the Knowledgebase 530 or with any otherelements of the current disclosure as needed.

User Specific Information 532, or User Specific Info 532, may comprisehardware, software or a combination of hardware and software for storinginformation pertaining to a specific user. There may be plurality ofUser Specific Infos 532 on the system, one for each user. User SpecificInfo 532 may include the information on the most prevalent Operations610 or Instruction Sets 600 the user may be using, information ondatabases on which the user may have most often performed operations,information on types of Operations 610 or Instruction Sets 600 the usermost often performs, information on the sequence of Operations 610 orInstruction Sets 600 which the user may perform or have performed mostoften, and more. User Specific Info 532 may further include theinformation along with a timestamp for each Operation 610 or InstructionSet 600 which the user has performed in the past, thereby allowing thesystem to determine which Operations 610 or Instruction Sets 600 theuser has most recently been using and which Operations 610 orinstruction Sets 600 the user has not used in a while.

Group Specific Information 534, or Group Specific Info 534, may comprisehardware, software or a combination of hardware and software for storinginformation pertaining to a group of users. The group of users may be agroup having a particular access level to the AI DBMS, such as forexample group of administrators, group of general users, group ofmanagers, group of guests, and more. Each group may be given a differentaccess level and different level of control over the system. There maybe plurality of or Group Specific Infos 534 on the system, one for eachgroup of users. Group Specific info 534 may include the information onthe most prevalent Operations 610 or Instruction Sets 600 the users ofthe group may be using, information on databases on which the users ofthe group may have most often performed operations, information on typesof operations the users of the group most often perform, information onthe sequence of Operations 610 or Instruction Sets 600 which the usersof the group may perform or have perform most often, and more. GroupSpecific info 534 may further include the information along with atimestamp for each Operation 610 or Instruction Set 600 which the usersof the group have performed in the past, thereby allowing the system todetermine which Operations 610 or instruction Sets 600 the users of thegroup have most recently been using and which Operations 610 orinstruction Sets 600 the user have not used in a while.

In some embodiments, the Core Program 110 and the Underlying DBMS 120may be provided as distinct elements executing on the same computingdevice.

Referring to FIG. 13B, an embodiment is illustrated in which the CoreProgram 110 may execute on the User's 10 Mobile Device 20 and theUnderlying DBMS 120 may execute on a remote Computing Device 1310.Remote Computing Device 1310 may be any device remote from the MobileDevice 20, such as a remote computer, a remote server, a remote MobileDevice 20, or another similar type of remote computing device to whichthe Core Program 110 may connect over the Network 1300. In thisimplementation, the Core Program 110 may use a database interface and/oran associated API for the Java platform to connect to the remote DBMS,One of ordinary skill in the art will recognize that the remoteComputing Device 1310 may include any functionality of a Mobile Device20, including any memory, processing and/or similar components which maybe utilized by the features of the present disclosure.

Referring to FIG. 14, an embodiment is illustrated in which theUnderlying DBMS 120 may execute on the User's 10 Mobile Device 20 andthe Core Program 110 may execute on a remote Computing Device 1310, andthe Core Program 110 may connect to the local Underlying DBMS 120 overthe Network 1300. In this implementation, the Core Program 110 may use adatabase interface and/or an associated API for the platform where itruns to connect to the local Underlying DBMS 120.

Referring to FIG. 15A, an embodiment is illustrated in which the CoreProgram 110 includes Underlying DBMS Functionality 121. In thisintegrated implementation, the Core Program 110 includes databaselibraries (not shown) comprising subroutines configured to performdatabase operations including low-level operations such as locking,transaction logging, shared buffer management, memory management, andother operations. Database libraries may include definitions of one ormore interfaces for database and application connectivity andinterfacing via an internal or external, socket-based, bridge-based, orother type of connection, Database libraries may also define instructionsets, operations, DBMS commands, instructions or any computer commandsthe Underlying DBMS Functionality 121 can accept and understand, anddefine handling of any SQL statements or any DBMS commands orinstruction sets. Database libraries may be configured to execute on anytype of operating system. The Core Program 110 may include one or moredatabase files. Each database file may be a computer file configured tostore data in an integrated collection of structured records. Eachdatabase file may be accessed by the database library. In thisintegrated implementation, database operations may be performed usingpre-made or custom database libraries that may be loaded and linked atthe initiation of the Core Program 110.

Referring to FIG. 15B, an embodiment is illustrated in which theUnderlying DBMS 120 may include DBMS Artificial intelligence 130. Inthis integrated implementation, DBMS Artificial Intelligence 130 may beor may directly or operatively connect to internal functions, processes,libraries, files, data structures, and/or other elements of theUnderlying DBMS 120. Underlying DBMS 120 may be, directly oroperatively, connected to the Input Interface 140, the Output Interface160, and/or other elements to facilitate the overall system operationand implement the functionalities described herein. The Core Program 110may optionally be omitted in this integrated implementation.

In some embodiments, Knowledgebase 530 may be local (i.e. localKnowledgebase 530) and it may reside on the User's 10 Mobile Device 20.Such local Knowledgebase 530 may be stored in a local table, local file,or other local data structure or data repository, and it may include“knowledge” of the use of the Underlying DBMS 120 by the local User 10(i.e. owner of the mobile device).

Referring to FIG. 16, an embodiment is illustrated in whichKnowledgebase 530 (i.e. global Knowledgebase 530) may reside on a remoteComputing Device 1310 (i.e. application server, etc.) on a Network 1300(i.e. corporate enterprise network. Internet, etc.). Such globalKnowledgebase 530 may be stored in a remote table, remote file, or otherremote data structure or data repository. Furthermore, such globalKnowledgebase 530 may include “knowledge” (i.e. Knowledge Cells 800) ofthe use of the Underlying DBMS 120 by any number of Users 10 wherever onthe Network 1300 they may be located. In turn, all these Users 10 mayutilize the global Knowledgebase 530 to anticipate their futureoperating intentions (i.e. future Operations 610 or Instruction Sets600). In one implementation, global Knowledgebase 530 may reside on aremote Computing Device 1310 on the Internet as an online service to allthe world's Users 10 who wish to disclose their use of the UnderlyingDBMS 120 and/or utilize the global Knowledgebase 530 to automate theirDBMS operation with AI DBMS functionalities described herein.

In some embodiments, AI DBMS may include DBMS Artificial Intelligence130 (i.e. local DBMS Artificial Intelligence 130) residing and executingon the User's 10 Mobile Device 20.

Referring to FIG. 17A, an embodiment is illustrated in which DBMSArtificial intelligence 130 (i.e. global DBMS Artificial Intelligence130) may reside and execute on a remote Computing Device 1310 (i.e.application server, etc.) on a Network 1300. In this implementation, theCore Program 110 executing on the Mobile Device 20 may connect with theDBMS Artificial Intelligence 130 through the Network 1300 to achievedesired results.

Referring to FIG. 17B, the illustration shows an embodiment of a method1700 for predicting instruction sets that the user is most likely to usenext, based on sequences of prior used instruction sets. The method maytherefore be used by a user on a mobile device operating an interfacefor an AI DBMS to perform operations on the back-end DBMS (i.e.Underlying DBMS 120).

In brief overview, at step 1705, a mobile device receives a sequence ofinstruction sets for performing operations on a database. The sequencemay include an order of consecutive instruction sets, such as forexample a first instruction set followed by a second instruction set. Atstep 1710, the first and second instruction sets are processed intoinstruction set portions. At step 1715, the sequence of the instructionsets is stored, along with their corresponding portions of instructionsets, into a knowledgebase that comprises plurality of instruction setsequences along with their corresponding portions. At step 1720, themobile device receives a new instruction set for performing an operationon a database. At step 1725, the new instruction set is processed intoinstruction set portions. At step 1730, one or more portions of the newinstruction set is compared with the portions of instruction sets in theknowledgebase. At step 1735, a determination is made that there is asubstantial similarity between the one or more portions of the newinstruction set and one or more portions of the first instruction set.At step 1737, the new instruction set is executed by performing, on adatabase, an operation corresponding to the new instruction set. At step1740, the second instruction set, along with its portions, is displayedon the mobile device as options to be selected by a user. At step 1745,the second instruction set or any of its portions are modified, shouldthe user decide to modify the second instruction set or its portions. Atstep 1750, the operation defined by the second instruction set (or themodified second instruction set) is performed on the database.

At step 1705, a mobile device receives a sequence of instruction sets.Each instruction set may indicate or identify one or more operations tobe performed on some data in some database. The sequence may include afirst instruction set, followed by a second instruction set, which mayalso be followed by a third instruction set, and so on. Any instructionset may be received by the interface for a DMBS. Any instruction set maybe received by any component of the AI DBMS. Instruction sets of thesequence may be received by the mobile device, or by any other mobiledevice or a computing device in general.

At step 1710, the first and the second instruction sets of the sequenceof instruction sets are processed into instruction set portions. In someembodiments, each of the instruction sets from the sequence aredisassembled or parsed into portions. In other embodiments, theinstruction sets are separated into commands, keywords, instructions,operators, variables, values, objects, functions and/or othercomponents, etc, Processing may also include identifying the type ofeach instruction set, in terms of the commands used. Specifically,determinations may be made to identify if each instruction set is formodifying data, selecting data, accessing data, creating a database,creating a row or a column within a database, making a new entry, etc,Processing may further include creating a timestamp of the time wheneach instruction set has been received or executed, Processing mayfurther include identifying a user which entered each instruction set oridentifying a group to which the user belongs. Processing may includeassigning a weight to each of the instruction sets or their potions.Processing may further include creating any extra information pertinentfor facilitating AI DBMS functionalities described herein, Processingmay include any action or operation by or for a Command Disassembler500.

At step 1715, the sequence of instruction sets is stored into aknowledgebase, along with the portions of the instruction sets. Theknowledgebase may comprise any number of instruction sets, instructionset portions and/or instruction set sequences, each of which may bestored in various arrangements, including tables, databases, DBMSs,memory structures, data structures, etc. in some embodiments,knowledgebase may include sequences of instruction sets, instructionsets and/or instruction set portions from the mobile device via whichthe sequences of instruction sets, instruction sets and/or instructionset portions are received. In other embodiments, knowledgebase mayinclude sequences of instruction sets, instruction sets and/orinstruction set portions from any number of computing devices.Knowledgebase or additional knowledgebases may also be populated toinclude the user specific and/or group specific informations gatheredwith respect to the instruction set. Also stored in knowledgebase may bethe weight assigned to each instruction set or its portions. Storing mayinclude any action or operation by or for a Knowledgebase 530 orKnowledge Structuring Unit 520.

At step 1720, a new instruction set for performing an operation on adatabase is received by the mobile device. The new instruction set mayidentify or indicate any operation to be performed on a databaseindicated herein. For instance, the new instruction set may include aninstruction to select, add, delete, or modify an entry; add, delete, ormodify a column; add, delete, or modify a table; add, delete, or modifya database; add, delete, or modify a relation; add, delete, or modify auser account; etc. The one or more portions of the new instruction setmay be for performing some operation on some database managed by the AIDBMS. The new instruction set or one or more of its portions may bestored into operation lists.

At step 1725, the new instruction set is processed into instruction setportions. In some embodiments, the new instruction set is disassembledor parsed into portions, which may include commands, keywords,instructions, operators, variables, values, objects, functions and/orother components, etc. Processing may also include identifying the typeof the new instruction set, in terms of the commands used. Specificallydeterminations may be made to identify if the new instruction set is formodifying data, selecting data, accessing data, creating a database,creating a row or a column within a database, making a new entry, etc.Processing may further include creating a timestamp of the time when thenew instruction set has been received. Processing may further includeidentifying a user which entered the new instruction set or identifyinga group to which the user belongs. Processing may include assigning aweight to each of the new instruction sets or their potions. Processingmay further include creating any extra information pertinent forfacilitating AI DBMS functionalities described herein. Processing mayinclude any action or operation by or for a Command Disassembler 500.

At step 1730, one or more portions of the new instruction set iscompared with the portions of instruction sets in the knowledgebase. Inone embodiment, the one or more portions of the new instruction set arecompared as a single string of characters with a plurality of portionsof instruction sets in the knowledgebase. In other embodiments,comparison may be implemented by treating each instruction set portionas a separate string to be matched independently. In furtherembodiments, comparison is implemented by matching all of one or moreportions of the new instruction set with one or more portions of aninstruction set stored in a knowledgebase. Comparison may be implementedby matching all but one of the one or more portions of the newinstruction set with one or more portions of an instruction set storedin a knowledgebase. Comparison may also be implemented by matching allbut two of one or more portions of the new instruction set with one ormore portions of an instruction set stored in a knowledgebase. In someembodiments, comparison may also be implemented by comparing the one ormore portions of the new instruction set with portions of theinstruction sets from the knowledgebase, factoring in the weights foreach of the instruction set portions from the knowledgebase. As suchmatching some portions of the instruction set from the knowledgebase maybe more important than other portions having smaller weight. In furtherembodiments, comparison may be implemented by comparing the newinstruction set with the instruction sets from the knowledgebase,factoring in the weights for each of the instruction sets from theknowledgebase. As such matching some of the instruction sets from theknowledgebase may be more important than other instruction sets havingsmaller weight.

At step 1735, a determination is made if there is a substantialsimilarity between the one or more portions of the new instruction setand one or more portions of the instruction sets stored in theknowledgebase, such as the first instruction set. In one embodiment,during the comparison of the one or more portions of the new instructionset and the portions of the first instruction set a perfect match may befound. In other embodiments, AI DBMS may find a plurality of perfectmatches with a plurality of stored instruction sets. If the number ofmatches exceeds a threshold for maximum number of substantial similarityresults, strictness level for determining a substantial match may bemodified to include an additional one or more portions of the newinstruction set in order to narrow down or reduce the number of theperfect matching results. In some embodiments, if no perfect match isfound, or if a number of matches is lower than a threshold for minimumamount of substantially matching results, then strictness level may bereduced to allow for finding a match that is imperfect. In someembodiments, a strictness level may be reduced to allow for a match formore important portions of the one or more portions of the newinstruction set to be matched with the instruction sets in theknowledgebase. The more important portions of the one or more portionsof the new instruction set may be portions including command words orkeywords. For example, a substantial match may be found when SQLkeywords from the one or more portions of the new instruction set matchSQL keywords, and/or the order of such keywords, in one or more storedinstruction sets in the knowledgebase, even if one or more variablenames, data names or database names are not matched. Substantial matchmay also be found when a strictness level is reduced to allow a match tohave all but one of the one or more portions of the new instruction setmatching an instruction set in the knowledgebase. Similarly, asubstantial match may be found when a strictness level is reduced toallow a match to have all but two of the one or more portions of the newinstruction set matching an instruction set in the knowledgebase.Likewise, a substantial match may be found when a strictness level isreduced to allow a match to have all but three of the one or moreportions of the new instruction set matching an instruction set in theknowledgebase. The one, two, or three non-matched portions of theinstruction set may be portions having smaller or smallest weight. Forexample, the non-matched portions of the instruction set may be variablenames, database names or other portions of the instruction set that maybe less important than the commands or keywords, for example.Determination of substantial similarity between the one or more portionsof the new instruction set and the first instruction set may include anyone of, or any combination of, substantial similarity determinationtechniques or embodiments discussed herein.

At step 1737, the new instruction set is executed by performing, on adatabase, operation indicated by, or corresponding to, the newinstruction set. In some embodiments, the new instruction set may beexecuted earlier or later in the process or not executed at all. Theoperation performed may include creating or deleting a database. Theoperation performed may include adding or deleting an entry within adatabase. The operation performed may include adding or deleting a rowor a column within a database. The operation performed may includeselecting an entry within a database. The operation performed mayinclude any DBMS operation described herein.

At step 1740, the mobile device displays the second instruction set orits portions as options to be selected by a user. The second instructionset may be displayed in response to determining that the firstinstruction set is the most substantial match with the new instructionset and that the second instruction set immediately follows the firstinstruction set. In some embodiments, AI DBMS may select the secondinstruction set for display on the mobile device responsive to thedetermination at step 1735, In further embodiments, the secondinstruction set may be displayed along with one or more instruction setsthat may immediately follow the second instruction set.

At step 1745, the second instruction set may be modified. In oneexample, the second instruction set may be modified to indicate the samedatabase, as was indicated in the new instruction set. In anotherexample, the second instruction set may be modified to indicate the sametable or report/view, as was indicated in the new instruction set. In afurther example, the second instruction set may be modified to indicatethe same column or entry, as was indicated in the new instruction set,etc.

At step 1750, the operation defined by, or corresponding to, the secondinstruction set or the modified second instruction set is performed on adatabase. The operation performed may include one of, or a combinationof: accessing, modifying, creating or deleting a database. The operationperformed may include one of, or a combination of: accessing, modifying,creating or deleting a table of a database. The operation performed mayinclude one of, or a combination of: accessing, modifying, creating ordeleting of a row, column, or cell within a table of a database. Theoperation performed may include one of, or a combination of: accessing,modifying, creating or deleting a report/view, relation, user account,and/or other objects in a DBMS. The operation performed may include anyDBMS operation described herein.

Referring to FIG. 18, in some aspects, the teaching presented by thecurrent disclosure may be implemented to include an associative methodof constructing Operations 610 or Instruction Sets 600. This embodimentmay enable a user to create an Operation 610 or Instruction Set 600(i.e. enter instruction set portions) by inputting Keys 2110 of an inputdevice (i.e. Keyboard 150, touch screen, wheel controls, remote control,etc.) where each Key 2110 may be associated with an Instruction SetPortion 620 of the Operation 610 or instruction Set 600. As such, User10 may use Keys 2110 associated with instruction Set Portions 620 toinput key by key (i.e. instruction set portion by instruction setportion) an Operation 610 or Instruction Set 600; until the usercompletes inputting the entire Operation 610 or Instruction Set 600, AKey 2110 may include any press-able key of the Keyboard 150, anypush-able button of the Mobile Device 20 or an external input device(i.e. joystick, etc.), any touch-able areas of a touch screen, anyclick-able component of the Mobile Device 20 or an external input device(i.e. mouse, etc.), any slide-able component of the Mobile Device 20 oran external input device, a text field; selectable list, drop-down menu,or other graphical or physical elements that may enable a User 10 toinput instructions or data.

As shown for example in FIG. 18, User 10 may use Mobile Device 20 thatmay include the Core Program 110; the Underlying DBMS 120; the inputInterface 140; the Keyboard 150, the Output Interface 160, the Display170; the Memory 180, the Physical Storage Medium 181, and theAssociative DBMS Command Constructor 190. Other additional elements maybe included as needed, or some of the disclosed ones may be excluded, ora combination thereof may be utilized in alternate embodiments.

Referring to FIG. 19, Associative DBMS Command Constructor 190 maycomprise any hardware, software or a combination of hardware andsoftware, and/or it may include functions and algorithms forconstructing an Operation 610 or Instruction Set 600. Associative DBMSCommand Constructor 190 may include functions and algorithms forconstructing an Operation 610 or Instruction Set 600 by associating Keys2110 of a Keyboard 150 for example, with Instruction Set Portions 620 ofthe Operation 610 or Instruction Set 600. Associative DBMS CommandConstructor 190 may include functions and algorithms for constructing anOperation 610 or Instruction Set 600 by associating Keys 2110 of aKeyboard 150 for example, with Instruction Set Portions 620 of theOperation 610 or Instruction Set 600 based on the Level 2000 in theconstructing process. The Associative DBMS Command Constructor 190 maybe, directly or operatively, connected to the Core Program 110 and/orother elements to facilitate the overall system operation and implementthe functionalities described herein.

Associative DBMS Command Constructor 190 may include an AssociativeControl Unit 1900; a Key Association Database 1910, a Key Re-associationUnit 1920, an Associative Selection Creator 1930, and a CommandAssembler 560. Other additional elements may be included as needed, orsome of the disclosed ones may be excluded, or a combination thereof maybe utilized in alternate embodiments.

Referring to FIG. 20, Associative Control Unit 1900 may comprise anyhardware, software or a combination of hardware and software, and/or itmay include functions and algorithms for managing and/or controlling theOperation 610 or Instruction Set 600 construction process. AssociativeControl Unit 1900 may include functions and algorithms for (1)recognizing the type of Operation 610 or Instruction Set 600 the User 10is constructing, (2) associating the instruction Set Portions 620 withthe Levels 2000 based on the type of Operation 610 or Instruction Set600, (3) keeping track of the Level 2000 up to which the Operation 610or Instruction Set 600 is constructed, and/or (4) storing the inputtedinstruction Set Portions 620 within the Operation 610. The AssociativeControl Unit 1900 may be, directly or operatively, connected to the CoreProgram 110, the Key Association Database 1910, the Key Re-associationUnit 1920, the Associative Selection Creator 1930, and the CommandAssembler 560 and/or other elements to facilitate the overall systemoperation and implement the functionalities described herein.

In one example, at the initiation of the Associative DBMS CommandConstructor 190, User 10 may be offered a Selection 2300 of the type ofthe Operation 610 or Instruction Set 600 the User 10 wishes to constructbased on the LVL1 Association Table 2100 within the Key AssociationDatabase 1910. User 10 may press the “1” Key 2110 on the Keyboard 150.The “1” Key 2110 may be associated with the “SELECT” Instruction SetPortion 620 within the LVL1 Association Table 2100. The “SELECT”instruction Set Portion 620 indicates the type of Operation 610 orInstruction Set 600 as the SELECT type of Operation 610 or instructionSet 600 (i.e. SELECT type SQL statement), and therefore it may be storedin a data field of the Operation 610 and associated with the LVL1 Level2000. The next instruction Set Portion 620 that is at LVL2 Level 2000may be the “FROM” keyword that has only one association (i.e. “FROM”)for the SELECT type Operation 610 or Instruction Set 600 and no User 10selection may be needed. The next Selection 2300 the User 10 is offeredmay be at LVL3 Level 2000 to choose the “Tbl1, Tbl2 . . . ” representingthe names of tables from which to obtain data. The next Selection 2300the User 10 is offered may be at LVL4 Level 2000 to choose the “Col1,Col2.” representing the columns to be selected. The next Selection 2300the User 10 is offered may be at LVL5 Level 2000 to choose the “WHERE”,“ORDER BY”, or “GROUP BY” keyword. In the case of “1” Key 2110 beingpressed by the User 10 at LVL5 Level 2000 indicating the “WHERE”Instruction Set Portion 620, the next Selection 2300 the User 10 isoffered may be at LVL6 Level 2000 to choose the “Col1 Operator1 Val1 ANDCol2 Operator2 Val2 . . . ” representing columns, operators and valuesused in restricting output results. Since the “Col1 Operator1 Val1 ANDCol2 Operator2 Va12 . . . ” Instruction Set Portion 620 may contain morethan one object, operator and/or value, sub-selections may be offeredfor each. The next Selection 2300 the User 10 is offered may be at LVL7Level 2000 to choose the “WHERE”, “ORDER BY”, or “GROUP BY” keyword. Inthe case of “2” Key 2110 being pressed by the User 10 at LVL7 Level 2000indicating the “ORDER BY” Instruction Set Portion 620, the nextSelection 2300 the User 10 is offered may be at LVL8 Level 2000 tochoose the “Col1, Col2 . . . ” representing columns by which to sort theresulting data set. The next Selection 2300 the User 10 is offered maybe at LVL9 Level 2000 to choose the “WHERE”, “ORDER BY”, or “GROUP BY”keyword. In the case of “3” Key 2110 being pressed by the User 10 atLVL9 Level 2000 indicating the “GROUP BY” Instruction Set Portion 620,the next Selection 2300 the User 10 is offered may be at LVL10 Level2000 to choose the “Col1, Col2 . . . ” representing columns by which togroup the resulting data set. Other Instruction Set Portions 620 notshown may be utilized in alternate embodiments such as functionsincluding MIN( ) MAX( ) SUMO, FIRST( ) LAST( ) etc.; operators includingOR, LESS THAN, GREATER THAN, etc.; objects including databases,relations, user accounts, privileges, etc.; etc.

In some aspects of the current disclosure, the purpose of Levels 2000may be to rearrange the inherent SQL (if SQL is used as the instructionset type to perform AI DBMS operations) order of constructing Operations610 or Instruction Sets 600 in a user friendly order in which the User10 (i.e. non-technical user) thinks of constructing Operations 610 orinstruction Sets 600, This option to rearrange the order is availablewhere rearrangement is appropriate or where the User 10 chooses.Therefore, as shown in FIG. 20, after the “SELECT” keyword at LVL1 Level2000, the “FROM” keyword is executed at LVL2 Level 2000, the “Tbl1, Tbl2. . . ” selection is executed at LVL3 Level 2000, the “Col1, Col2 . . .” selection is executed at LVL4 Level 2000, and so forth. This userfriendly order of constructing the Operation 610 or Instruction Set 600may be preferred by the User 10 because it allows the User 10 to firstselect a table from a list of tables within the database and then selectcolumn(s) from a list of columns within the selected table. Conversely,the inherent SQL syntax such as for example “SELECT Col1, Col2 FROM Tbl1Tbl2, . . . , etc.” assumes (often wrongly) that the user knows whichcolumns are included within the table. Any Instruction Set Portions 620or other components of the Operation 610 or Instruction Set 600 may berearranged using Levels 2000 and/or any order of rearrangement may beutilized.

At each Level 2000 the Associative Control Unit 1900 may interact with(1) the Control Program 110 to receive the User's 10 inputted Key 2110,(2) the Key Association Database 1910 to obtain the Association Table2100 containing the Instruction Set Portions 620 appropriate for thecurrently inputted Key 2110 and the currently executing Level 2000, (3)the Key Re-association Unit 1920 that re-associates the Keys 2110 of theKeyboard 150 with the appropriate Instruction Set Portions 620 for thecurrently executing Level 2000, (4) the Associative Selection Creator1930 that creates the Selections 2300 appropriate for the currentlyexecuting Level 2000, and/or (5) other elements. When all neededInstruction Set Portions 620 at their respective Levels 2000 areinputted the Associative Control Unit 1900 may send the completedOperation 610 to the Command Assembler 560 for assembling theInstruction Set 600 for execution. In some embodiments, KeyRe-association Unit 1920 may optionally be omitted. In such embodiments,Associative Control Unit 1900 may receive the User's 10 inputted Key2110 from the Control Program 110 and look up the associated instructionSet Portion 620 in the Association Table 2100 containing the InstructionSet Portions 620 appropriate for the currently inputted Key 2110 and thecurrently executing Level 2000.

Referring to FIG. 21, Key Association Database 1910 may comprise anyhardware, software or a combination of hardware and software, and/or itmay include functions and algorithms for storing the associationsbetween Keys 2110 and the corresponding Instruction Set Portions 620.Key Association Database 1910 may include functions and algorithms forproviding one or more Association Tables 2100 where each AssociationTable 2100 may include a column for the Keys 2110 and a column for thecorresponding Instruction Set Portions 620 appropriate for the currentlyexecuting Level 2000. The Key 2110 column in the Association Table 2100may represent the Keys 2110 on the mobile device's Keyboard 150, TheInstruction Set Portion 620 or Inst Set Por column may represent theInstruction Set Portions 620 of an Operation 610 or instruction Set 600appropriate for the currently executing Level 2000. Key AssociationDatabase 1910 may be, directly or operatively, connected to theAssociative Control Unit 1900 and/or other elements to facilitate theoverall system operation and implement the functionalities describedherein.

In some embodiments, an Association Table 2100 may be implemented in anytable, a database, linked arrays, linked queues, a hash table, or anydata structure that can store associated elements (i.e. column-valuepairs, etc.), Any or all Association Tables 2100 within a KeyAssociation Database 1910 may be included in one Association Table 2100in alternate embodiments. Association Tables 2100 may be pre-defined forevery possible operation on each of the objects (i.e. tables, databases,etc.) in the Underlying DBMS 120. If pre-defined, Association Tables2100 may change as the objects in the Underlying DBMS 120 change. Forexample, if the name of a database in the Underlying DBMS 120 changes,the Association Tables 2100 used for key associations related to thisdatabase may change to reflect the changed database name. Alternatively,Association Tables 2100 may be created on-fly or as needed inanticipation of the upcoming Instruction Set Portion 620 that the User10 may wish to enter.

Referring to FIG. 22, Key Re-association Unit 1920 may comprise anyhardware, software or a combination of hardware and software, and/or itmay include functions and algorithms for associating or re-associatingKeys 2110 of an input device (i.e. Keyboard 150, mouse, touch screen,control wheel, remote control, etc.) with Instruction Set Portions 620of an Operation 610 or instruction Set 600, Key Re-association Unit 1920may include functions and algorithms for associating or re-associatingKeys 2110 of an input device (i.e. Keyboard 150, mouse, touch screen,control wheel, remote control, etc. with Instruction Set Portions 620 ofan Operation 610 or Instruction Set 600 appropriate for the currentlyexecuting Level 2000. As shown for example in FIG. 22, at LVL7 Level2000 the “1”, “2”, and “3” Keys 2110 may be associated with “WHERE”,“ORDER BY”, and “GROUP BY” Instruction Set Portions 620 respectively.Once the User 10 presses the “2” Key 2110 for example, KeyRe-association Unit 1920 may re-associate the Keys 2110 of the Keyboard150 using the LVL8 Association Table 2100 as shown. Key Re-associationUnit 1920 may be, directly or operatively, connected to the AssociativeControl Unit 1900, the Core Program 110 and/or other elements tofacilitate the overall system operation and implement thefunctionalities described herein.

Referring to FIG. 23A, Associative Selection Creator 1930 may compriseany hardware, software or a combination of hardware and software, and/orit may include functions and algorithms for creating or re-creatingSelections 2300 for consideration by the user. Associative SelectionCreator 1930 may include functions and algorithms for creating orre-creating Selections 2300 for consideration by the user appropriatefor the currently executing Level 2000. As shown for example in FIG.23A, at LVL7 Level 2000 the Display 170 may include a Selection 2300that shows “WHERE”, “ORDER BY”, and “GROUP BY” Instruction Set Portions620 and their associated Keys 2110. Once the User 10 presses the “2” Key2110 for example, Associative Selection Creator 1930 may create aSelection 2300 using the LVL8 Association Table 2100 as shown.Associative Selection Creator 1930 may be, directly or operatively,connected to the Associative Control Unit 1900, the Core Program 110and/or other elements to facilitate the overall system operation andimplement the functionalities described herein.

In some embodiments, the associative method of constructing Operations610 or instruction Sets 600 may include Command Assembler 560, whichCommand Assembler 560 may be, directly or operatively, connected to theAssociative Control Unit 1900, the Core Program 110 and/or otherelements to facilitate the overall system operation and implement thefunctionalities described herein. Once all the needed Instruction SetPortions 620 are inputted at their respective Levels 2000 as tracked bythe Associative Control Unit 1900, the complete Operation 610 may besent to the Command Assembler 560 for assembling of the Instruction Set600 for execution. The functioning of the Command Assembler 560 isequivalent of the Command Assembler 560 previously described.

In other embodiments, the associative method of constructing Operations610 or instruction Sets 600 may construct an instruction Set 600 withoutever using the Operation 610 as an intermediary data structure to storeInstruction Set Portions 620. For example, as the User 10 inputs therequired Instruction Set Portions 620 as tracked by the AssociativeControl Unit 1900 at various Levels 2000, the Associative Control Unit1900 may append the incoming instruction Set Portions 620 as strings ofcharacters to arrive at a complete Instruction Set 600. In thisimplementation without using Operations 610, Command Assemblers 560functionality may be omitted or not fully utilized.

Referring to FIG. 23B, the illustration shows an embodiment of a method6300 for associative construction of instruction sets through key input.The method may therefore be used by a user on a mobile device operatingan interface for an AI DBMS to perform operations on the back-end DBMS(i.e. Underlying DBMS 120).

In brief overview, at step 6305, a plurality of collections ofinstruction set portions to be used to assemble a new instruction setfor performing an operation on a database are maintained on a mobiledevice. At step 6310, the keys of the mobile device are associated withthe instruction set portions of the first collection. At step 6315,instruction set portions of the first collection along with theirassociated keys are displayed on the mobile device for a selection by auser. At step 6320, user selects a first key associated with aninstruction set portion of the first collection. At step 6325, a firstportion of the new instruction set is assembled using the instructionset portion associated with the selected first key. At step 6330, thekeys of the mobile device are re-associated with instruction setportions of the second collection. At step 6335, the instruction setportions of the second collection along with their associated keys aredisplayed on the mobile device. At step 6340, the user selects a secondkey associated with an instruction set portion of the second collection.At step 6345, a second portion of the new instruction set is assembledusing the instruction set portion associated with the second key. Atstep 6347, a determination is made if the new instruction set can bedetermined using method 7400 later described. At step 6350, steps6330-6347 are repeated for all subsequent portions of the newinstruction set until the new instruction set's completion. At step6355, the operation defined by the new instruction set is performed onthe database.

In further detail, at step 6305, a plurality of collections ofinstruction set portions are maintained on a mobile device. Theinstruction set portions may be used to assemble a new instruction setfor performing an operation on some data in a database. The collectionsof instruction set portions may be maintained, organized and/or storedin various arrangements including tables, databases. DBMSs, memorystructures, data structures, etc. In some embodiments, the collectionsof instruction set portions may be ordered to include a firstcollection, followed by a second collection, which may also be followedby a third collection, and so on, to complete the instruction set. Thefirst collection of instruction set portions may include all possible ormost likely first instruction set portions where the user may selectamong the possibilities, the second collection of instruction setportions may include all possible or most likely second instruction setportions where the user may select among the possibilities, and so on.In some embodiments, the collections of instruction set portions may bepre-defined for all possible or most used operations on each of theobjects (i.e. tables, databases, reports/views, relations, useraccounts, etc.) in the DBMS and the collections of instruction setportions may change as the objects in the DBMS change. In otherembodiments, the collections of instruction set portions may be createdon-fly or as needed in anticipation of the upcoming instruction setportion that the user may wish to enter.

At step 6310, the keys of the mobile device are associated with theinstruction set portions of the first collection. A key may include anypress-able key of a keyboard, any push-able button of the mobile device,any touch-able areas of a touch screen, any click-able component of themobile device, any slide-able component of the mobile device, a textfield, selectable list, drop-down menu, or other physical or graphicalelements that may enable a user to input instructions or data. Keys ofany internal or external input device such as keyboard, mouse, touchscreen, control wheel, remote control, etc. may be used and/orassociated with the instruction set portions of the first collection. Insome embodiments, the first collection of instruction set portions maybe included in a data structure such as a table comprising a column forthe keys and a column for the associated instruction set portions of thefirst collection. Therefore, an association may be established between akey and an instruction set portion of the first collection in the samerow of the table. Associating may include any action or operation by orfor a Key Re-association Unit 1920.

At step 6315, instruction set portions of the first collection alongwith their associated keys are displayed on the mobile device for aselection by a user. The user may view on the display of the mobiledevice which keys of the mobile device may be associated with specificinstruction set portions of the first collection. In some embodiments,the display may include keys pointing with arrows or other such signs orindicia to their associated instruction set portions of the firstcollection indicating the associations for user's consideration.Displaying may include any action or operation by or for an AssociativeSelection Creator 1930.

At step 6320, user selects a first key associated with an instructionset portion of the first collection. The first key may be received bythe interface for a DMBS. The first key may be received by the mobiledevice, or by any other mobile device or a computing device in general.The first key may be received by any component of the AI DBMS. User mayselect the first key by using a key of the mobile device associated withone of the instruction set portions of the first collection. Theassociated instruction set portion of the first collection may identifyor indicate one or more commands, keywords, instructions, operators,variables, values, objects, functions and/or other components of the newinstruction set to be assembled.

At step 6325, a first portion of the new instruction set is assembledusing the instruction set portion associated with the selected firstkey. In some embodiments, assembling may include storing the firstinstruction set portion in a data structure such as an array, linkedlist, table, etc. comprising all known instruction set portions of thenew instruction set. In other embodiments, assembling may includeappending the first instruction set portion to a string of characters(in the case of the first instruction set portion an empty string)containing the known instruction set portions of the new instructionset. Assembling may include any action or operation by or for anAssociative Control Unit 1900.

At step 6330, the keys of the mobile device are re-associated withinstruction set portions of the second collection. Step 6330 may includeany action or operation described in Step 6310 as applicable.

At step 6335, the instruction set portions of the second collectionalong with their associated keys are displayed on the mobile device.Step 6335 may include any action or operation described in Step 6315 asapplicable.

At step 6340, the user selects a second key associated with aninstruction set portion of the second collection. Step 6340 may includeany action or operation described in Step 6320 as applicable.

At step 6345, a second portion of the new instruction set is assembledusing the instruction set portion associated with the second key. Step6345 may include any action or operation described in Step 6325 asapplicable.

At step 6347, a determination is made if the new instruction set can bedetermined using method 7400 later described. In some embodiments,method 7400 may be used for predicting the new instruction set bycomparing its known instruction set portions with instruction setportions of prior stored instructions sets. Therefore, if enoughinstruction set portions of the new instruction set are known the newinstruction set may be identified before the user inputs all neededinstruction set portions.

At step 6350, steps 6330-6347 are repeated for all subsequent portionsof the new instruction set until the new instruction set's completion.Steps 6330-6347 may be performed repeatedly with subsequent collectionsof instruction set portions to assemble the new instruction set oneinstruction set portion at a time. Once all the needed instruction setportions are known the new instruction set may be complete. Inembodiments where the intermediary data structure (i.e. array, linkedlist, table, etc.) is used for storing known instruction set portions ofthe new instruction set as previously described, the complete newinstruction set may be assembled from the instruction set portions inthe data structure before being sent to DBMS for execution. Assemblingmay include any action or operation by or for a Command Assembler 560.In embodiments where appending is performed of known instruction setportions the new instruction set as previously described, the completenew instruction set may be directly sent to DBMS for execution:

At step 6355, the operation defined by the new instruction set isperformed on the database. The operation defined by, or correspondingto, the assembled new instruction set is executed on a DBMS. Theoperation performed may include one of, or a combination of: accessing,modifying, creating or deleting a database. The operation performed mayinclude one of, or a combination of: accessing, modifying, creating ordeleting a table of a database. The operation performed may include oneof, or a combination of: accessing, modifying, creating or deleting of arow, column, or cell within a table of a database. The operationperformed may include one of, or a combination of: accessing, modifying,creating or deleting a report/view, relation, user account, and/or otherobjects in a DBMS. The operation performed may include any DBMSoperation described herein.

Referring to FIG. 24, in some aspects, the teaching presented by thecurrent disclosure may be implemented to include a Simplified DBMSCommand Language (SDCL) for associative Operation 610 or instruction Set600 construction. In some embodiments, SDCL may include collections ofPhrases 2610 that a non-technical user may typically associate withInstruction Set Portions 620 of an Operation 610 or instruction Set 600.Phrase 2610 may include one or more letters, one or more numbers, one ormore symbols, one or more alphanumeric or any other characters, a word,an acronym, a group of words or acronyms, or a sentence each includingall of its semantic variations. User 10 may input Phrases 2610 throughthe Keyboard 150, touch screen, key pad, or any other input device thatincludes a means of inputting instructions or data. These embodimentsmay enable a non-technical user to create Operations 610 or InstructionSets 600 through an associative method in which each Phrase 2610 may beassociated with an Instruction Set Portion 620 of the Operation 610 orInstruction Set 600.

As shown in FIG. 24, User 10 may use a Mobile Device 20 that may includethe Core Program 110, the Underlying DBMS 120, the Input Interface 140,the Keyboard 150, the Output Interface 160, the Display 170, the Memory180, the Physical Storage Medium 181, and the Associative SDCLConstructor 2400, Other additional elements may be included as needed,or some of the disclosed ones may be excluded, or a combination thereofmay be utilized in alternate embodiments.

Referring to FIG. 25, Associative SDCL Constructor 2400 may comprise anyhardware, software or a combination of hardware and software, and/or itmay include functions and algorithms for constructing an Operation 610or Instruction Set 600. Associative SDCL Constructor 2400 may includefunctions and algorithms for constructing an Operation 610 orInstruction Set 600 by associating Phrases 2610 with Instruction SetPortions 620 of the Operation 610 or Instruction Set 600. AssociativeSDCL Constructor 2400 may include functions and algorithms forconstructing an Operation 610 or Instruction Set 600 by associatingPhrases 2610 with Instruction Set Portions 620 of the Operation 610 orInstruction Set 600 appropriate for the currently executing Level 2000.Associative SDCL Constructor 2400 may be, directly or operatively,connected to the Core Program 110 and/or other elements to facilitatethe overall system operation and implement the functionalities describedherein,

Associative SDCL Constructor 2400 may include Associative Control Unit1900, SDCL Association Database 2500, Phrase Re-association Unit 2510,Associative Selection Creator 2520, and Command Assembler 560, Otheradditional elements may be included as needed, or some of the disclosedones may be excluded, or a combination thereof may be utilized inalternate embodiments.

Referring to FIG. 26A, SDCL Association Database 2500 may comprise anyhardware, software or a combination of hardware and software, and/or itmay include functions and algorithms for storing associations betweenPhrases 2610 and the corresponding Instruction Set Portions 620. SDCLAssociation Database 2500 may include functions and algorithms forproviding Association Tables 2100 where each Association Table 2100 mayinclude a column for the Phrases 2610 and a column for the correspondingInstruction Set Portions 620 appropriate for the currently executingLevel 2000, The Phrase 2610 column in the Association Table 2100 mayrepresent Phrases 2610 that User 10 (i.e. non-technical user) maytypically associate with the Instruction Set Portions 620 of anOperation 610 or Instruction Set 600. The Instruction Set Portion 620 orInst Set Por column may represent the Instruction Set Portions 620 of anOperation 610 or instruction Set 600 appropriate for the currentlyexecuting Level 2000, SDCL Association Database 2500 may be, directly oroperatively, connected to the Associative Control Unit 1900 and/or otherelements to facilitate the overall system operation and implement thefunctionalities described herein.

In one example, at the initiation of the Associative SDCL Constructor2400, User 10 may input or select a Phrase 2610 “GET DATA”. The Phrase2610 “GET DATA” may be associated with the “SELECT” Instruction SetPortion 620 within the LVL1 Association Table 2100. The “SELECT”instruction Set Portion 620 indicates the type of Operation 610 orInstruction Set 600 as the SELECT type of Operation 610 or instructionSet 600 (i.e. SELECT type SQL statement), and therefore it may be storedin a data field of the Operation 610 and associated with the LVL1 Level2000. The next Phrase 2610 the User 10 may be required to input orselect is at LVL2 Level 2000 to input or select one of the Phrases 2610associated with the keyword “FROM”. The next Phrase 2610 the User 10 maybe required to input or select is at LVL3 Level 2000 to input or select“Tbl1, Tbl2 . . . ” representing the names of tables from which toobtain data. The next Phrase 2610 the User 10 may be required to inputor select is at LVL4 Level 2000 to input or select “Col1, Col2 . . . ”representing the columns to be selected. The next Phrase 2610 the User10 may be required to input or select is at LVL5 Level 2000 to input orselect “WHERE”, “ORDER BY”, or “GROUP BY” keyword. In the case of“FILTER” Phrase 2610 being inputted or selected by the User 10 at LVL5Level 2000 indicating the “WHERE” Instruction Set Portion 620, the nextPhrase 2610 the User 10 may be required to input or select is at LVL6Level 2000 to input or select “Col1 Operator1 Val1 AND Col2 Operator2Va12 . . . ” representing columns, operators and values used inrestricting output results. Since “Col1 Operator1 Val1 AND Col2Operator2 Va12 . . . ” may contain more than one object, operator and/orvalue, sub-inputs may be required for each in one embodiment. The nextPhrase 2610 the User 10 may be required to input or select is at LVL7Level 2000 to input or select “WHERE”, “ORDER BY”, or “GROUP BY”keyword. In the case of “SORT” Phrase 2610 being inputted or selected bythe User 10 at LVL7 Level 2000 indicating the “ORDER BY” Instruction SetPortion 620, the next Phrase 2610 the User 10 may be required to inputor select is at LVL8 Level 2000 to input or select “Col1 Col2 . . . ”representing columns by which to sort the resulting data set. The nextPhrase 2610 the User 10 may be required to input or select is at LVL9Level 2000 to input or select “WHERE”, “ORDER BY”, or “GROUP BY”keyword, in the case of “SUMMARIZE” Phrase 2610 being inputted orselected by the User 10 at LVL9 Level 2000 indicating the “GROUP BY”Instruction Set Portion 620, the next Phrase 2610 the User 10 may berequired to input or select is at LVL10 Level 2000 to input or select“Col1, Col2 . . . ” representing columns by which to group the resultingdata set. Other instruction Set Portions 620 not shown may be utilizedin alternate embodiments such as functions including MIN( ), MAX( ),SUM( ), FIRST( ), LAST( ), etc.; operators including OR, LESS THAN,GREATER THAN, etc.; objects including databases, relations, useraccounts, privileges, etc.; etc.

At each Level 2000 the Associative Control Unit 1900 may interact with(1) the Control Program 110 to obtain the User's 10 inputted or selectedPhrase 2610, (2) the SDCL Association Database 2500 to obtain theAssociation Table 2100 containing the Instruction Set Portions 620appropriate for the currently inputted Phrase 2610 and currentlyexecuting Level 2000, (3) the Phrase Re-association Unit 2510 thatre-associates Phrases 2610 with appropriate Instruction Set Portions 620for the currently executing Level 2000, (4) the Associative SelectionCreator 2520 that creates the Selections 2300 appropriate for thecurrently executing Level 2000, and/or (5) other elements. When allneeded Instruction Set Portions 620 at their respective Levels 2000 areinputted or selected the Associative Control Unit 1900 may send thecompleted Operation 610 to the Command Assembler 560 for assembling theInstruction Set 600 for execution. In some embodiments, PhraseRe-association Unit 2510 may optionally be omitted. In such embodiments,Associative Control Unit 1900 may receive the User's 10 inputted Phrase2610 from the Control Program 110 and look up the associated InstructionSet Portion 620 in the Association Table 2100 containing the InstructionSet Portions 620 appropriate for the currently inputted Phrase 2610 andthe currently executing Level 2000.

An extended example of the LVL1 Association Table 2100 may be asfollows:

PHRASE INST SET POR SELECT SELECT GET DATA SELECT SHOW DATA SELECT FINDDATA SELECT OBTAIN DATA SELECT UPDATE UPDATE CHANGE DATA UPDATE MODIFYDATA UPDATE REVISE DATA UPDATE DELETE DELETE ERASE DATA DELETE REMOVEDATA DELETE INSERT INTO INSERT INTO ADD DATA INSERT INTO INSERT DATAINSERT INTO CREATE TABLE CREATE TABLE ADD TABLE CREATE TABLE INSERTTABLE CREATE TABLE ALTER TABLE ALTER TABLE CHANGE TABLE ALTER TABLEUPDATE TABLE ALTER TABLE MODIFY TABLE ALTER TABLE REVISE TABLE ALTERTABLE DROP TABLE DROP TABLE DELETE TABLE DROP TABLE ERASE TABLE DROPTABLE REMOVE TABLE DROP TABLE CREATE VIEW CREATE VIEW ADD VIEW CREATEVIEW INSERT VIEW CREATE VIEW ALTER VIEW REPLACE VIEW CHANGE VIEW REPLACEVIEW UPDATE VIEW REPLACE VIEW MODIFY VIEW REPLACE VIEW REVISE VIEWREPLACE VIEW DROP VIEW DROP VIEW DELETE VIEW DROP VIEW ERASE VIEW DROPVIEW REMOVE VIEW DROP VIEW CREATE INDEX CREATE INDEX ADD INDEX CREATEINDEX INSERT INDEX CREATE INDEX DROP INDEX DROP INDEX DELETE INDEX DROPINDEX ERASE INDEX DROP INDEX REMOVE INDEX DROP INDEX CREATE DATABASECREATE DATABASE ADD DATABASE CREATE DATABASE INSERT DATABASE CREATEDATABASE DROP DATABASE DROP DATABASE DELETE DATABASE DROP DATABASE ERASEDATABASE DROP DATABASE REMOVE DATABASE DROP DATABASE . . . . . .

It should be understood that Phrases 2610 and their associatedInstruction Set Portions 620 included in this LVL1 Association Table2100 are examples of some possible Phrases 2610 that may be included inthis LVL1 Association Table 2100 or any other Association Table 2100.Any Phrases 2610 and their associated instruction Set Portions 620included in this LVL1 Association Table 2100 or any other AssociationTable 2100 may be defined by the User 10 or system administrator, or byAI DBMS itself through a Phrase 2610 recording process (i.e. recordinguser phrases as the user uses them and asking the user to assignassociated Instruction Set Portions 620). Phrases 2610 and theirassociated instruction Set Portions 620 may also be defined based on thetype of DBMS application, experience, testing, logs, inquiry, analysis,synthesis or other techniques in alternate implementations. In general,other additional Phrases 2610 and their associated Instruction SetPortions 620 may be included as needed, or some of the disclosed onesmay be excluded, or a combination thereof may be utilized in alternateembodiments.

Phrase Re-association Unit 2510 may comprise any hardware, software or acombination of hardware and software, and/or it may include functionsand algorithms for associating or re-associating Phrases 2610 withInstruction Set Portions 620 of an Operation 610 or instruction Set 600.Phrase Re-association Unit 2510 may include functions and algorithms forassociating or re-associating Phrases 2610 with Instruction Set Portions620 of an Operation 610 or Instruction Set 600 appropriate for thecurrently executing Level 2000. For example, at LVL7 Level 2000 thePhrase Re-association Unit 2510 may associate Phrases 2610 withInstruction Set Portions 620 using the LVL7 Association Table 2100containing Instruction Set Portions 620 “WHERE”, “ORDER BY”, and “GROUPBY” and their associated Phrases 2610. Once User 10 inputs a Phrase 2610“SORT” for example indicating “ORDER BY” Instruction Set Portions 620,Phrase Re-association Unit 2510 may re-associate Phrases 2610 using theLVL8 Association Table 2100 containing instruction Set Portions 620“Col1”, “Col2”, etc. and their associated Phrases 2610 indicating thecolumns by which to sort the resulting data set. Phrase Re-associationUnit 2510 may be, directly or operatively, connected to the AssociativeControl Unit 1900, the Core Program 110 and/or other elements tofacilitate the overall system operation and implement thefunctionalities described herein. Phrase Re-association Unit 2510 mayinclude some or all the features and embodiments of the previouslydescribed Key Re-association Unit 1920.

Associative Selection Creator 2520 may comprise any hardware, softwareor a combination of hardware and software, and/or it may includefunctions and algorithms for creating or re-creating Selections 2300 forconsideration by the user. Associative Selection Creator 2520 mayinclude functions and algorithms for creating or re-creating Selections2300 for consideration by the user appropriate for the currentlyexecuting Level 2000. For example, at LVL7 Level 2000 the Display 170may include a Selection 2300 that may show entries of the LVL7Association Table 2100 containing instruction Set Portions 620 “WHERE”,“ORDER BY”, and “GROUP BY” and their associated Phrases 2610. Once User10 inputs a Phrase 2610 “SORT” for example indicating “ORDER BY”Instruction Set Portions 620, Associative Selection Creator 2520 maycreate a Selection 2300 using the LVL8 Association Table 2100 containinginstruction Set Portions 620 “Col1”, “Col2”, etc. and their associatedPhrases 2610 indicating the columns by which to sort the resulting dataset. Associative Selection Creator 2520 may be, directly or operatively,connected to the Associative Control Unit 1900, the Core Program 110and/or other elements to facilitate the overall system operation andimplement the functionalities described herein. Associative SelectionCreator 2520 may include some or all the features and embodiments of thepreviously described Associative Selection Creator 1930.

In some embodiments. User 10 may input an entire sentence that may thenbe matched against Association Tables 2100 to decipher the Phrases 2610and/or their associated Instruction Set Portions 620. For example, User10 may input a sentence “SHOW DATA IN Tbl4”. The words in this sentencemay then be matched with the Phrases 2610 in LVL1 Association Table 2100and it is found that “SHOW DATA” is a Phrase 2610 within the LVL1Association Table 2100, The Phrase 2610 “SHOW DATA” may be associatedwith the “SELECT” Instruction Set Portion 620, it may indicate the typeof Operation 610 or Instruction Set 600 as the SELECT type of Operation610 or Instruction Set 600 0.e. SELECT type SQL statement), andtherefore it may be stored in a data field of the Operation 610 andassociated with LVL1 Level 2000. The words in the rest of the sentence(“IN Tbl4”) may then be matched with the Phrases 2610 in LVL2Association Table 2100 and it is found that “IN” is a Phrase 2610 withinthe LVL2 Association Table 2100, The Phrase 2610 “IN” may be associatedwith the “FROM” Instruction Set Portion 620 and therefore it may bestored in a data field of the Operation 610 and associated with LVL2Level 2000. The words in the rest of the sentence (“Tbl4”) may then bematched with the Phrases 2610 in LVL3 Association Table 2100 and it isfound that “Tbl4” is a Phrase 2610 within the LVL3 Association Table2100. The Phrase 2610 “Tbl4” may be associated with the “Tbl4”Instruction Set Portion 620 and therefore it may be stored in a datafield of the Operation 610 and associated with LVL3 Level 2000. Thedescribed matching process may continue for any number of words orphrases in the sentence and for any number of Association Tables 2100.If User 10 wishes to construct a longer or more detailed Operation 610or Instruction Set 600 that may include filtered, sorted, and/orsummarized results, etc. additional Phrases 2610 and/or theirinstruction Set Portions 620 may then be obtained from the User 10 inthe associative process previously described.

Referring to FIG. 26B, the illustration shows an embodiment of a method2600 for associative construction of instruction sets through phraseinput. The method may therefore be used by a user on a mobile deviceoperating an interface for an AI DBMS to perform operations on theback-end DBMS (i.e. Underlying DBMS 120).

In brief overview, at step 2605, a plurality of collections ofinstruction set portions to be used to assemble a new instruction setfor performing an operation on a database are maintained on a mobiledevice. At step 2610, user preferred phrases are associated with theinstruction set portions of the first collection. At step 2615,instruction set portions of the first collection along with theirassociated phrases are displayed on the mobile device for a selection bya user. At step 2620, user inputs or selects a first phrase associatedwith an instruction set portion of the first collection. At step 2625, afirst portion of the new instruction set is assembled using theinstruction set portion associated with the selected first phrase. Atstep 2630, the phrases are re-associated with instruction set portionsof the second collection. At step 2635, the instruction set portions ofthe second collection along with their associated phrases are displayedon the mobile device. At step 2640, the user inputs or selects a secondphrase associated with an instruction set portion of the secondcollection. At step 2645, a second portion of the new instruction set isassembled using the instruction set portion associated with the secondphrase. At step 2647, a determination is made if the new instruction setcan be determined using method 7400 later described. At step 2650, steps2630-2647 are repeated for all subsequent portions of the newinstruction set until the new instruction set's completion. At step2655, the operation defined by the new instruction set is performed onthe database.

In further detail, at step 2605, a plurality of collections ofinstruction set portions are maintained on a mobile device. Theinstruction set portions may be used to assemble a new instruction setfor performing an operation on some data in a database. The collectionsof instruction set portions may be maintained, organized and/or storedin various arrangements including tables, databases. DBMSs, memorystructures, data structures, etc. In some embodiments, the collectionsof instruction set portions may be ordered to include a firstcollection, followed by a second collection, which may also be followedby a third collection, and so on, to complete the instruction set. Thefirst collection of instruction set portions may include all possible ormost likely first instruction set portions where the user may selectamong the possibilities, the second collection of instruction setportions may include all possible or most likely second instruction setportions where the user may select among the possibilities, and so on.In some embodiments, the collections of instruction set portions may bepre-defined for all possible or most used operations on each of theobjects (i.e. tables, databases, reports/views, relations, useraccounts, etc.) in the DBMS and the collections of instruction setportions may change as the objects in the DBMS change. In otherembodiments, the collections of instruction set portions may be createdon-fly or as needed in anticipation of the upcoming instruction setportion that the user may wish to enter.

At step 2610, user preferred phrases are associated with the instructionset portions of the first collection. In some embodiments, a phrase mayinclude one or more letters, one or more numbers, one or more symbols,one or more alphanumeric or any other characters, a word, an acronym, agroup of words or acronyms, or a sentence each including all of itssemantic variations. In some embodiments, user preferred phrases mayinclude phrases that a non-technical user may typically associate withinstruction set portions of an instruction set such as the newinstruction set, Phrases may be inputted through any internal orexternal input device such as keyboard, mouse, touch screen, controlwheel, remote control, microphone, etc. In some embodiments, the firstcollection of instruction set portions may be included in a datastructure such as a table comprising a column for the phrases and acolumn for the associated instruction set portions of the firstcollection. Therefore, an association may be established between aphrase and an instruction set portion of the first collection in thesame row of the table. Associating may include any action or operationby or for a Phrase Re-association Unit 2510.

At step 2615, instruction set portions of the first collection alongwith their associated phrases are displayed on the mobile device for aselection by a user. The user may view on the display of the mobiledevice which phrases may be associated with specific instruction setportions of the first collection. In some embodiments, the display mayinclude phrases pointing with arrows or other such signs or indicia totheir associated instruction set portions of the first collectionindicating the associations for user's consideration. Displaying mayinclude any action or operation by or for an Associative SelectionCreator 2520.

At step 2620, user inputs or selects a first phrase associated with aninstruction set portion of the first collection. The first phrase may bereceived by the interface for a DMBS. The first phrase may be receivedby the mobile device, or by any other mobile device or a computingdevice in general. The first phrase may be received by any component ofthe AI DBMS. User may input or select the first phrase by using thekeyboard of the mobile device for example, and the first phrase may beassociated with one of the instruction set portions of the firstcollection. The associated instruction set portion of the firstcollection may identify or indicate one or more commands, keywords,instructions, operators, variables, values, objects, functions and/orother components of the new instruction set to be assembled.

At step 2625, a first portion of the new instruction set is assembledusing the instruction set portion associated with the selected firstphrase. In some embodiments, assembling may include storing the firstinstruction set portion in a data structure such as an array, linkedlist, table, etc. comprising all known instruction set portions of thenew instruction set. In other embodiments, assembling may includeappending the first instruction set portion to a string of characters(in the case of the first instruction set portion an empty string)containing the known instruction set portions of the new instructionset. Assembling may include any action or operation by or for anAssociative Control Unit 1900.

At step 2630, the phrases are re-associated with instruction setportions of the second collection, Step 2630 may include any action oroperation described in Step 2610 as applicable.

At step 2635, the instruction set portions of the second collectionalong with their associated phrases are displayed on the mobile device.Step 2635 may include any action or operation described in Step 2615 asapplicable.

At step 2640, the user inputs or selects a second phrase associated withan instruction set portion of the second collection. Step 2640 mayinclude any action or operation described in Step 2620 as applicable.

At step 2645, a second portion of the new instruction set is assembledusing the instruction set portion associated with the second phrase,Step 2645 may include any action or operation described in Step 2625 asapplicable.

At step 2647, a determination is made if the new instruction set can bedetermined using method 7400 later described. In some embodiments,method 7400 may be used for predicting the new instruction set bycomparing its known instruction set portions with instruction setportions of prior stored instructions sets. Therefore, if enoughinstruction set portions of the new instruction set are known the newinstruction set may be identified before the user inputs all neededinstruction set portions.

At step 2650, steps 2630-2647 are repeated for all subsequent portionsof the new instruction set until the new instruction set's completion.Steps 2630-2647 may be performed repeatedly with subsequent collectionsof instruction set portions to assemble the new instruction set oneinstruction set portion at a time, Once all the needed instruction setportions are known the new instruction set may be complete, inembodiments where the intermediary data structure (i.e. array, linkedlist, table, etc.) is used for storing known instruction set portions ofthe new instruction set as previously described, the complete newinstruction set may be assembled from the instruction set portions inthe data structure before being sent to DBMS for execution. Assemblingmay include any action or operation by or for a Command Assembler 560.In embodiments where appending is performed of known instruction setportions the new instruction set as previously described, the completenew instruction set may be directly sent to DBMS for execution.

At step 2655, the operation defined by the new instruction set isperformed on the database. The operation defined by, or correspondingto, the assembled new instruction set is executed on a DBMS. Theoperation performed may include one of, or a combination of: accessing,modifying, creating or deleting a database. The operation performed mayinclude one of, or a combination of: accessing, modifying, creating ordeleting a table of a database. The operation performed may include oneof, or a combination of: accessing, modifying, creating or deleting of arow, column, or cell within a table of a database. The operationperformed may include one of, or a combination of: accessing, modifying,creating or deleting a report/view, relation, user account, and/or otherobjects in a DBMS. The operation performed may include any DBMSoperation described herein.

Referring to FIG. 27, in some aspects, the teaching presented by thecurrent disclosure may be implemented to include a SDCL for associativeOperation 610 or Instruction Set 600 construction and speech recognitionfor voice input.

As shown in FIG. 27, User 10 may use a Mobile Device 20 that may includethe Core Program 110, the Underlying DBMS 120, the Input Interface 140,the Keyboard 150, the Output Interface 160, the Display 170, the Memory180, the Physical Storage Medium 181, the Associative SDCL Constructor2400, the Speech Recognizer 2700, and the Microphone 2710. Otheradditional elements may be included as needed, or some of the disclosedones may be excluded, or a combination thereof may be utilized inalternate embodiments.

In some embodiments, Speech Recognizer 2700 may comprise any hardware,software or a combination of hardware and software, and/or it mayinclude functions and algorithms for processing input events of theMicrophone 2710 for use by the Core Program 110 or other elements of thecurrent disclosure, Speech Recognizer 2700 may include functions andalgorithms for “listening” to voice events on the Microphone 2710,interpreting the voice events as User's 10 voice commands, andtransmitting the voice commands for use by the Core Program 110. SpeechRecognizer 2700 may fall under the general description of the previouslydescribed Input Interface 140, and while it includes all theaforementioned embodiments, it is described separately in thisembodiment to offer additional detail on its functioning. SpeechRecognizer 2700 may be implemented by utilizing (1) a Mobile Device 20operating system's speech recognition functionality such as iOS's VoiceServices, Siri, etc. which may come inherently as the part of the mobiledevice package; (2) a Java Speech API (JSAPI) or any of itsimplementations such as The Cloud Garden, Sphinx, etc.; or (3)applications or engines providing speech recognition functionality suchas OpenEars, Dragon Mobile, iSpeech, CeedVocal, Flite, Julius, etc, AIDBMS with Speech Recognizer 2700 may enable User 10 to constructOperations 610 or Instruction Sets 600 (1) by issuing voice commands(i.e. phrases, etc.) combined with the associative SDCL constructingprocess previously described, (2) by issuing voice commands combinedwith the key associative DBMS command constructing process previouslydescribed, or (3) by issuing voice commands only.

In some embodiments, AI DBMS may use the Mobile Device 20 operatingsystem's speech recognition functionality as the Speech Recognizer 2700.The Core Program 110 may use the operating system's native speechrecognition API such as the iOS Voice Services to obtain User's 10 voicecommands. This way, Microphone 2710 may detect User's 10 voice event;the iOS Voice Services may interpret the voice event as User's 20 voicecommand and make the voice event available as data (i.e. text,instruction, instruction set, command, object, data structure, etc.) tothe Core Program 110; and the Core Program 110 may pass the data to theAssociative SDCL Constructor 2400 as a Phrase 2610 for associating withInstruction Set Portions 620.

In other embodiments, AI DBMS may use a Java Speech API (JSAPI)implementation as the Speech Recognizer 2700. The Core Program 110 mayuse a JSAPI implementation such as The Cloud Garden to obtain User'svoice commands. This way, Microphone 2710 may detect User's 10 voiceevent; the Cloud Garden JSAPI may interpret the voice event as User's 20voice command and make the voice event available as data (i.e. text,instruction, instruction set, command, object, data structure, etc.) tothe Core Program 110; and the Core Program 110 may pass the data to theAssociative SDCL Constructor 2400 as a Phrase 2610 for associating withInstruction Set Portions 620.

In further embodiments, AI DBMS may use applications or enginesproviding speech recognition functionality as the Speech Recognizer2700. The Core Program 110 may use an application or engine such as theOpenEars Software Development Kit (SDK) to obtain User's voice commands.This way, Microphone 2710 may detect User's 10 voice event; the OpenEarsSDK may interpret the voice event as User's 20 voice command and makethe voice event available as data (i.e. text, instruction, instructionset, command, object, data structure, etc.) to the Core Program 110; andthe Core Program 110 may pass the data to the Associative SDCLConstructor 2400 as a Phrase 2610 for associating with Instruction SetPortions 620.

Depending on resource availability Speech Recognizer 2700 may beimplemented as keyword spotting or as full speech recognition. Keywordspotting may attempt to find only a select group of words and/orphrases, and because of this limited lexicon it consumes fewerresources, in the case of keyword spotting implementation, Phrases 2610within Association Tables 2100 may define the select group of wordsand/or phrases to be searched. Full speech recognition may attempt tofind all the words and/or phrases that have been spoken, and because ofthis broader lexicon it consumes significant resources. In the case offull speech recognition implementation, the broadness of words and/orphrases would by definition include all the Phrases 2610 within theAssociation Tables 2100. In some embodiments, both keyword spotting andfull speech recognition implementations may include a database of wordsand/or phrases located locally on the Mobile Device 20 or remotely on aremote Computing Device 1310 accessible over the Network 1300.

Microphone 2710 may comprise any hardware, software or a combination ofhardware and software, and/or it may include functions and algorithmsfor receiving and/or detecting User's voice events or inputs. Mostmodern mobile devices include Microphone 2710 as one of the inputdevices.

Referring to FIG. 28, in some aspects, the teaching presented by thecurrent disclosure may be implemented to include artificial intelligence(i.e. machine learning and/or anticipation functionalities, etc.) toanticipate Instruction Set Portions 620 in an Operation 610 orInstruction Set 600 construction process. This embodiment may enable auser to input one or more Instruction Set Portions 620 of an Operation610 or Instruction Set 600 and AI DBMS may anticipate one or moresubsequent Instruction Set Portions 620 or the entire Operation 610 orInstruction Set 600 that the User 10 may want or is most likely toimplement. The anticipation of Instruction Set Portions 620 may becombined with (1) the previously described associative method ofconstructing Operations 610 or Instruction Sets 600 via phrase input,(2) the previously described associative method of constructingOperations 610 or Instruction Sets 600 via key input, and/or (3) anyother method, system, element, or feature of the current disclosure.

An embodiment is illustrated in FIG. 28 where the anticipation ofinstruction Set Portions 620 may be combined with the previouslydescribed associative method of constructing Operations 610 orInstruction Sets 600 via phrase input. Associative SDCL Constructor 2400may comprise any hardware, software or a combination of hardware andsoftware, and/or it may include functions and algorithms forconstructing an Operation 610 or Instruction Set 600 by associatingPhrases 2610 with instruction Set Portions 620 of the Operation 610 orInstruction Set 600 as previously described. In some embodiments,Associative SDCL Constructor 2400 may include artificial intelligence(Le, machine learning and/or anticipation functionalities, etc.) tolearn the Phrases 2610 that the User 10 used in the past and anticipatefuture Phrases 2610 and/or their associated instruction Set Portions 620to be used in the Operation 610 or instruction Set 600 constructionprocess. In other embodiments, Associative SDCL Constructor 2400 mayinclude artificial intelligence (i.e. machine learning and/oranticipation functionalities, etc.) to learn the Instruction SetPortions 620 that the User 10 used in the past and anticipate futureInstruction Set Portions 620 to be used in the Operation 610 orInstruction Set 600 construction process. Since Phrases 2610 may beassociated with Instruction Set Portions 620, a Phrase 2610 maycorrespond to a particular Instruction Set Portion 620 identified bythat particular Phrase 2610, and vice versa. Also, the Phrase 2610 maybe referred to as the Instruction Set Portion 620, and vice versa, asthis Instruction Set Portion 620 may be a representation of thisparticular Phrase 2610. In effect, a Phrase 2610 and its correspondingInstruction Set Portion 620 may be logical equivalents where theinstruction Set Portion 620 may be understood or preferred by the systemand the Phrase 2610 may be understood or preferred by the User 10.Therefore, Phrase 2610 and Instruction Set Portion 620 may be usedinterchangeably in descriptions of some embodiments. Associative SDCLConstructor 2400 may be, directly or operatively, connected to the CoreProgram 110 and/or other elements to facilitate the overall systemoperation and implement the functionalities described herein.

Associative SDCL Constructor 2400 may include the Associative ControlUnit 1900, the SDCL Association Database 2500, the Phrase Re-associationUnit 2510, the Associative Selection Creator 2520, the Command Assembler560, and the Associative SDCL Artificial Intelligence 2800. Otheradditional elements may be included as needed, or some of the disclosedones may be excluded, or a combination thereof may be utilized inalternate embodiments.

Referring to FIG. 29, in some embodiments, Associative SDCL Artificialintelligence 2800 may comprise any hardware, software or a combinationof hardware and software, and/or it may include functions and algorithmsfor anticipating User's 10 future Phrases 2610, Instruction Set Portions620, and/or full Operations 610 or Instruction Sets 600 in an Operation610 or Instruction Set 600 construction process. The Associative SDCLArtificial Intelligence 2800 may be, directly or operatively, connectedto the Associative Control Unit 1900 and/or other elements to facilitatethe overall system operation and implement the functionalities describedherein.

Associative SDCL Artificial Intelligence 2800 may include a Phrase List2910, a Knowledge Structuring Unit 2920, a Knowledgebase 2930, aDecision-making Unit 2940, and a User Confirmation Unit 2950. Otheradditional elements may be included as needed, or some of the disclosedones may be excluded, or a combination thereof may be utilized inalternate embodiments.

Referring to FIG. 30, Phrase List 2910 may comprise any hardware,software or a combination of hardware and software, and/or it mayinclude functions and algorithms for storing User's 10 recently usedPhrases 2610 or Instruction Set Portions 620. Phrase List 2910 mayinclude some or all the features and embodiments of the previouslydescribed Operation List 510. While FIG. 30 depicts examples of Phrases2610 that each includes only one textual element (i.e. string ofcharacters, etc.), a Phrase 2610 may be implemented to include one ormore portions of a textual element such as the previously describedInstruction Set Portions 620 in which case a Phrase 2610 may be orinclude a data structure such as the Operation 610 storing thoseportions of a textual element. Therefore, in one example, “Col1, Col2, .. . ” Phrase 2610 may be implemented as a data structure comprising“Col1” portion, “Col2” portion, and/or additional “ . . . ” portions.Phrase List 2910 may be, directly or operatively, connected to theAssociative Control Unit 1900, Knowledge Structuring Unit 2920, and theDecision-making Unit 2940 and/or other elements to facilitate theoverall system operation and implement the functionalities describedherein.

Phrase List 2910 may receive a Phrase 2610 or Instruction Set Portion620 from the Associative Control Unit 1900 and store any number ofPhrases 2610 or Instruction Set Portions 620 that were recently used orimplemented by the system. The number of Phrases 2610 or instruction SetPortions 620 recently used or implemented may vary depending on theembodiments and one of ordinary skill in the art would recognize thatthe number of stored Phrases 2610 or Instruction Set Portions 620 may beany number that may be stored in any memory or storage described hereinas previously described.

In one embodiment, in which the last five Phrases 2610 or instructionSet Portions 620 may be stored in the Phrase List 2910, Phrases 2610 orinstruction Set Portions 620 may be identified such that the currentPhrase 2610 or Instruction Set Portion 620 is identified as Phrase n,the most recent Phrase 2610 or Instruction Set Portion 620 prior to thecurrent may be identified as Phrase n−1, and so on until the least mostrecent Phrase 2610 or Instruction Set Portion 620 being stored islabeled as Phrase n−4. In such embodiments, each time the Phrase List2910 receives another new Phrase 2610 or Instruction Set Portion 620from the Associative Control Unit 1900, it may erase the least recentPhrase 2610 or Instruction Set Portion 620, such as Phrase n−4, andinsert the new Phrase 2610 or Instruction Set Portion 620 received asPhrase n. Naturally, all the most recently used or implemented Phrases2610 or instruction Set Portions 620 that are stored in this list orqueue may be shifted by one count further towards Phrase n−4. This way,the system may maintain a queue of stored recently used or implementedPhrases 2610 or instruction Set Portions 620, where the queue mayinclude any number of stored Phrases 2610 or Instruction Set Portions620 as previously described.

Still referring to FIG. 30, in one example, Phrase List 2910 mayrepresent a hypothetical situation where the User 10 startedconstructing a “SELECT” type of Operation 610 or Instruction Set 600with Phrases 2610 “SHOW DATA”, “IN”, “Tbl4”, “Col1, Col2 . . . ”, and“FILTER” that may be associated with Instruction Set Portions 620“SELECT”, “FROM”, “Tbl4”, “Col1, Col2 . . . ”, and “WHERE” respectively.

Referring to FIG. 31, Knowledge Structuring Unit 2920 may comprise anyhardware, software or a combination of hardware and software, and/or itmay include functions and algorithms for structuring the “knowledge” ofthe User's 10 use of Phrases 2610 or Instruction Set Portions 620 foranticipating future Phrases 2610 or Instruction Set Portions 620.Knowledge Structuring Unit 2920 may include functions and algorithms forstructuring the stored sequence (i.e. Phrase List 2910) of User's 10Phrases 2610 or Instruction Set Portions 620 into usable “knowledge” forfuture anticipating of the User's 10 Phrases 2610 or Instruction SetPortions 620, or operating intentions. Knowledge Structuring Unit 2920may include some or all the features and embodiments of the previouslydescribed Knowledge Structuring Unit 520. Knowledge Structuring Unit2920 may include the functionality to produce any variations of Phrases2610 or instruction Set Portions 620 that may ever be used by a user.The Knowledge Structuring Unit 2920 may be, directly or operatively,connected to the Phrase List 2910, Knowledgebase 2930, and/or otherelements to facilitate the overall system operation and implement thefunctionalities described herein.

In one example, Knowledge Structuring Unit 2920 may receive the currentPhrase List 2910 and may create a Knowledge Cell 801 by copying Phrase nfrom the Phrase List 2910 into Phrase n+2 of the Knowledge Cell 801, bycopying Phrase n−1 from the Phrase List 2910 into Phrase n+1 of theKnowledge Cell 801, by copying Phrase n−2 from the Phrase List 2910 intoPhrase n of the Knowledge Cell 801, and so forth. Knowledge Cell 801 maycomprise any hardware, software or a combination of hardware andsoftware, and/or it may include functions and algorithms for storing arecorded sequence of the User's 10 Phrases 2610 or Instruction SetPortions 620. In effect, when a Knowledge Cell 801 is created it mayinclude any data structure (i.e. array, list, linked list, table, etc.)that may store a recorded sequence of the User's 10 Phrases 2610 orInstruction Set Portions 620 where, for example, Phrase n, Phrase n−1,and Phrase n−2 may later be used for comparison with the then User's 10current and recent Phrases 2610 or Instruction Set Portions 620, andPhrase n+1 and Phrase n+2 may later be used for anticipation of theUser's 10 future Phrases 2610 or Instruction Set Portions 620. KnowledgeCell 801 may include some or all the features and embodiments of thepreviously described Knowledge Cell 800.

Referring to FIG. 32, in some embodiments, Knowledgebase 2930 maycomprise any hardware, software or a combination of hardware andsoftware, and/or it may include functions and algorithms for storing aplurality of Phrases 2610 or Instruction Set Portions 620. Knowledgebase2930 may include functions and algorithms for storing a plurality ofPhrases 2610 or Instruction Set Portions 620 generally structured intoone or more Knowledge Cells 801, although Phrases 2610 or InstructionSet Portions 620 may be stored directly in the Knowledgebase 2930 andneed not be structured into or use Knowledge Cells 801. Knowledgebase2930 may include the functionality for storing Knowledge Cells 801, orPhrases 2610 or instruction Set Portions 620 in a particular order toenable easier access and usage of stored data. Knowledgebase 2930 mayalso include the functionality for managing and/or modifying and/orproviding Knowledge Cells 801, or Phrases 2610 or Instruction SetPortions 620 as necessary. Knowledgebase 2930 may comprise thefunctionality to store and manage all the Knowledge Cells 801, orPhrases 2610 or instruction Set Portions 620 that were used orimplemented by any users in the past. Knowledgebase 2930 may store anyvariations of Knowledge Cells 801, or Phrases 2610 or instruction SetPortions 620 that may ever be used by a user. Knowledgebase 2930 mayinclude some or all the features and embodiments of the previouslydescribed Knowledgebase 530. Knowledgebase 2930 may be, directly oroperatively, connected to the Knowledge Structuring Unit 2920 and theDecision-making Unit 2940 and/or other elements to facilitate theoverall system operation and implement the functionalities describedherein.

As shown in FIG. 32, Knowledgebase 2930 may include a table (a verticalrepresentation of records in a table is shown), although, one or moretables, databases, files, or any other data structures or datarepositories may be used. Knowledgebase 2930 may include an entire DBMSdedicated to Knowledgebase 2930 functionalities in some embodiments. Forexample, in the case of a single table being used as the Knowledgebase2930, a Knowledge Cell 801 may be stored within the table where each ofthe Phrases 2610 or Instruction Set Portions 620 (such as for example:Phrase n+2, Phrase n+1, Phrase n, Phrase n−1, Phrase n−2, etc.) of theKnowledge Cell 801 may be a record with a common Knowledge Cellidentifier (ID) 901 that signifies its association with its parentKnowledge Cell 801, Later in the process, a simple call to the table toread all records with a specific Knowledge Cell ID 901 would reconstructthe Knowledge Cell 801. Knowledge Cell ID 901 may include some or allthe features and embodiments of the previously described Knowledge CellID 900. In other embodiments, all Phrases 2610 or Instruction SetPortions 620 (such as for example: Phrase n+2, Phrase n+1, Phrase n,Phrase n−1 , Phrase n−2, etc.) of a Knowledge Cell 801 may be stored ina single record within the table. Knowledgebase 2930 may reside withinthe Underlying DBMS 120 in some embodiments, or it may reside anywhereoutside the Underlying DBMS 120 in other embodiments.

Referring to FIG. 33, Decision-making Unit 2940 may comprise anyhardware, software or a combination of hardware and software, and/or itmay include functions and algorithms for anticipating User's 10 futurePhrases 2610 or Instruction Set Portions 620, and/or Operations 610 orInstruction Sets 600. Decision-making Unit 2940 may comprise algorithms,functions, rules and logic to enable the system to determine whichPhrase 2610 or Instruction Set Portion 620 the User 10 may intend or ismost likely to use or implement. Similarly, Decision-making Unit 2940may comprise the functionality to determine which Phrase 2610 orInstruction Set Portion 620 the user is second most likely to use orimplement, which Phrase 2610 or Instruction Set Portion 620 the user isthird most likely to use or implement, and so on. Furthermore,Decision-making Unit 2940 may comprise the functionality to determinethe sequence or order in which the user may intend or is most likely touse or implement Phrases 2610 or instruction Set Portions 620.Decision-making Unit 2940 may include some or all the features andembodiments of the previously described Decision-making Unit 540. TheDecision-making Unit 2940 may be, directly or operatively, connected tothe Phrase List 2910 and the Knowledgebase 2930 and/or other elements tofacilitate the overall system operation and implement thefunctionalities described herein.

In some embodiments, AI DBMS may anticipate one or more Phrases 2610 orinstruction Set Portions 620 the user may intend to enter while the User10 is entering initial Phrases 2610 or Instruction Set Portions 620 ofan Operation 610 or Instruction Set 600. In other embodiments, AI DBMSmay anticipate a full Operation 610 or Instruction Set 600 while theUser 10 is entering initial Phrases 2610 or Instruction Set Portions620.

Decision-making Unit 2940 may anticipate the User's 10 future Phrases2610 or Instruction Set Portions 620 by performing SubstantialSimilarity Comparisons 1020 between the current Phrase List 2910 and theKnowledge Cells 801 stored in the Knowledgebase 2930. SubstantialSimilarity Comparison 1020 and the included Comparison StrictnessFunction 1021 may include some or all the features and embodiments ofthe previously described Substantial Similarity Comparison 1010 andComparison Strictness Function 1011 respectively.

As previously described, Substantial Similarity Comparison 1020 maycomprise algorithms, functions and/or logic for performing matching orcomparisons and for determining that while a perfect match is not found,a substantially similar match has been found. Substantial SimilarityComparison 1020 may therefore identify a sequence of Phrases 2610 orInstruction Set Portions 620 from a Phrase List 2910 that is most like asequence of Phrases 2610 or Instruction Set Portions 620 from aKnowledge Cell 801 in a Knowledgebase 2930, even if the sequence ofPhrases 2610 or Instruction Set Portions 620 from the Phrase List 2910is different from the sequence of Phrases 2610 or Instruction SetPortions 620 in the Knowledge Cell 801. Furthermore, SubstantialSimilarity Comparison 1020 may also identify a Phrase 2610 orinstruction Set Portion 620 from a Phrase List 2910 that is most like aPhrase 2610 or Instruction Set Portion 620 from a Knowledge Cell 801 ina Knowledgebase 2930, even if the Phrase 2610 or instruction Set Portion620 from the Phrase List 2910 is different from the Phrase 2610 orInstruction Set Portion 620 in the Knowledge Cell 801.

As previously described, Comparison Strictness Function 1021 may alsoadjust the strictness level by choosing the number of Phrases 2610 orInstruction Set Portions 620 that it will use to find a substantialsimilarity match between the Phrases 2610 or Instruction Set Portions620 in the Phrase List 2910 and the corresponding (i.e. comparative)Phrases 2610 or instruction Set Portions 620 in the Knowledgebase 2930.For example, as a User 10 is inputting first three Phrases 2610 orInstruction Set Portions 620 of an Operation 610 or Instruction Set 600the User 10 may intend to implement, Comparison Strictness Function 1021may run these three Phrases 2610 or Instruction Set Portions 620 againstPhrases 2610 or Instruction Set Portions 620 in the Knowledgebase 2930,If the Substantial Similarity Comparison 1020 provides a number ofmatching results (results that have perfect equivalence) that is above aparticular threshold, the Comparison Strictness Function 1021 may decideto increase the strictness of the rules to decrease the number ofresults, AI DBMS may then decide to wait for the User 10 to add thefourth Phrase 2610 or instruction Set Portion 620, thereby allowing theSubstantial Similarity Comparison 1020 to use the fourth Phrase 2610 orinstruction Set Portion 620 in addition to the earlier three to find asmaller number of matching results. Once the user adds the fourth Phrase2610 or instruction Set Portion 620, the Substantial SimilarityComparison 1020 may use all four Phrases 2610 or instruction SetPortions 620 to find a match. If the number of matching results (resultsthat perfectly match, i.e. total equivalence) is sufficiently small, thesystem may present the User 10 with these results. If however, thenumber of matching results is still too high, the Comparison StrictnessFunction 1021 may determine to further increase the strictness byrequiring the user to add additional Phrases 2610 or Instruction SetPortions 620 and thereby further narrow the search results beforepresenting the user with the suggested results. In some embodiments,Phrases 2610 or Instruction Set Portions 620 added may include a portionof a command or a keyword, such as a first one or more letters of aPhrase 2610 or Instruction Set Portion 620.

Comparison Strictness Function 1021 may therefore increase and decreasethe strictness of the rules for finding a substantial similarity matchdepending on the number of Phrases 2610 or Instruction Set Portions 620the user has already entered and/or whether or not perfect matches hadbeen found. As such, Comparison Strictness Function 1021 may utilize twothresholds, the upper and a lower threshold, to determine the strictnessof the rules used for determining the substantial similarity match. Theupper threshold may correspond to the number of substantial similaritymatches that are too high to be presented to the user (i.e. too manymatching results, too vague suggestions). Alternatively, the lowerthreshold may correspond to the strictness level that results in too fewresults to be presented to the user. Comparison Strictness Function 1021may make any combination of the aforementioned adjustments to achievethat the number of substantial similarity matches falls between theupper and the lower threshold. As such, Comparison Strictness Function1021 may keep adjusting the strictness rules for finding thesubstantially similar match until both thresholds are satisfied, therebyadjusting the results until the best set of results is found.

Referring to FIG. 34A, in some embodiments, Confirmation Unit 2950 maycomprise any hardware, software or a combination of hardware andsoftware, and/or it may include functions and algorithms for confirmingthe User's 10 anticipated Phrases 2610 or Instruction Set Portions 620,and/or Operations 610 or instruction Sets 600 with the User 10.Confirmation Unit 2950 may comprise algorithms and functions to enablethe system to confirm the Phrases 2610 or Instruction Set Portions 620,and/or Operations 610 or Instruction Sets 600 that the AI DBMSdetermined (Le, via the substantial similarity comparison) could be thePhrases 2610 or instruction Set Portions 620, or Operations 610 orinstruction Sets 600 which the user may want to use or implement.Confirmation Unit 2950 may include some or all the features andembodiments of the previously described Confirmation Unit 550.Confirmation Unit 2950 may be, directly or operatively, connected to theDecision-making Unit 2940 and the Associative Control Unit 1900 and/orother elements to facilitate the overall system operation and implementthe functionalities described herein.

As shown in FIG. 34A, Confirmation Unit 2950 may include a SubstantiallySimilar Knowledge Cell 1111, a Context Interpreter 1121, a UserConfirmation 1131 process step, and the Phrase List 2910. Otheradditional elements may be included as needed, or some of the disclosedones may be excluded, or a combination thereof may be utilized inalternate embodiments. Substantially Similar Knowledge Cell 1111 ContextInterpreter 1121, and User Confirmation 1131 process step may includesome or all the features and embodiments of the previously describedSubstantially Similar Knowledge Cell 1110, Context Interpreter 1120, andUser Confirmation 1130 process step respectively.

The context in which the Phrases 2610 or Instruction Set Portions 620from the Phrase List 2910 were performed may be analyzed by the Contextinterpreter 1121. In one embodiment, context may be defined as anysub-segment of a Phrase 2610 or Instruction Set Portion 620 that is notused in the Substantial Similarity Comparison 1020, or any informationabout the Phrases 2610 or Instruction Set Portions 620 from the PhraseList 2910 that may be useful in anticipating User's 10 future Phrases2610 or Instruction Set Portions 620, or Operations 610 or InstructionSets 600. In effect, Context interpreter 1121 may represent an extraanalysis step and it may attempt to capture all information and/orelements that may have been omitted by the Substantial SimilarityComparison 1020, and/or by the other process steps or elements.

As previously described, an example of Context Interpreter's 1121usefulness is the fact that values may be omitted from SubstantialSimilarity Comparisons 1020 in some embodiments. It is ContextInterpreter's 1121 responsibility to discover the values or the rangesof values used in the User's recent Phrases 2610 or Instruction SetPortions 620 by extracting the values from the Phrases 2610 orInstruction Set Portions 620.

Referring to FIG. 34B, the illustration shows an embodiment of a method3400 for predicting instruction set portions that the user is mostlikely to use next, based on sequences of prior used instruction setportions. The method may therefore be used by a user on a mobile deviceoperating an interface for an AI DBMS to perform operations on theback-end DBMS (i.e. Underlying DBMS 120).

In brief overview, at step 3405, a mobile device receives a sequence offirst and second instruction set portions of an instruction set forperforming an operation on a database. The sequence may include an orderof consecutive instruction set portions, such as for example a firstinstruction set portion followed by a second instruction set portion. Atstep 3410, the sequence of the instruction set portions is stored into aknowledgebase that comprises plurality sequences of instruction setportions. At step 3415, the mobile device receives a new instruction setportion of a new instruction set for performing an operation on adatabase. At step 3420, the new instruction set portion is compared withinstruction set portions in the knowledgebase. At step 3425, adetermination is made that there is a substantial similarity between thenew instruction set portion and the first instruction set portion. Atstep 3430, the second instruction set portion is displayed on the mobiledevice as an option to be selected by a user. At step 3435, the secondinstruction set portion is modified in response to edits by the user,should the user decide to modify the second instruction set portion. Atstep 3440, a portion of the new instruction set is assembled using thenew instruction set portion and a different portion of the newinstruction set is assembled using the second instruction set portion orthe modified second instruction set portion. At step 3445, steps3415-3440 are repeated for all subsequent portions of the newinstruction set until the new instruction set's completion. At step3450, the operation defined by the new instruction set is performed onthe database.

In further detail, at step 3405, a mobile device receives a sequence offirst and second instruction set portions of an instruction set forperforming an operation on a database, Each instruction set portion mayindicate or identify one or more commands, keywords, instructions,operators, variables, values, objects, functions and/or other componentsof an instruction set for performing an operation on some data in somedatabase. The sequence may include a first instruction set portion,followed by a second instruction set portion, which may also be followedby a third instruction set portion, and so on. Instruction set portionsof the sequence may be received by the interface for a DMBS. Instructionset portions of the sequence may be received by any component of the AIDBMS. Instruction set portions of the sequence may be received by themobile device, or by any other mobile device or a computing device ingeneral.

At step 3410, the sequence of the instruction set portions is storedinto a knowledgebase that comprises plurality sequences of instructionset portions. The knowledgebase may comprise any number of instructionset portions and/or sequences of instruction set portions, each of whichmay be stored in various arrangements, including tables, database,memory structures, data structures, etc. In some embodiments,knowledgebase may include instruction set portions and/or sequences ofinstruction set portions from the mobile device via which theinstruction set portions and/or sequences are received. In otherembodiments, knowledgebase may include instruction set portions and/orsequences of instruction set portions from any number of computingdevices. Knowledgebase or additional knowledgebases may also bepopulated to include the user specific and/or group specificinformations gathered with respect to the instruction set portionsand/or sequences of instruction set portions. Also stored inknowledgebase may be the weight assigned to each instruction setportion.

At step 3415, the mobile device receives a new instruction set portionof a new instruction set for performing an operation on a database. Thenew instruction set portion may identify or indicate any commands,keywords, instructions, operators, variables, values, objects, functionsand/or other components of an instruction set for performing anoperation on a database indicated herein. For instance, the newinstruction set portion may include a keyword “DELETE” indicating anoperation to delete an entry in a database. In another example, the newinstruction set portion may include keyword(s) “CREATE TABLE” indicatingan operation to create a table in a database. The new instruction setportion may include any keyword(s) to indicate any other operations suchas for example to select, add, delete, or modify an entry; add, delete,or modify a column; add, delete, or modify a table; add, delete, ormodify a database; add, delete, or modify a relation; add, delete, ormodify a user account; etc. The new instruction set portion of the newinstruction set may be for performing some operation on some databasemanaged by the AI DBMS. The new instruction set portion may be storedinto instruction set portion lists.

At step 3420, the new instruction set portion is compared withinstruction set portions in the knowledgebase. In one embodiment, thenew instruction set portion may be compared as a single string ofcharacters with a plurality of instruction set portions in theknowledgebase. In other embodiments, comparison may be implemented bytreating each of one or more components (i.e. words, etc.) of aninstruction set portion as a separate string to be matchedindependently. In further embodiments, comparison may be implemented bymatching one or more components of the new instruction set portion withone or more components of the instruction set portions stored in aknowledgebase. In yet further embodiments, comparison may also beimplemented by matching all but one of one or more components of the newinstruction set portion with one or more components of an instructionset portion stored in a knowledgebase. Comparison may also beimplemented by matching all but two of one or more components of the newinstruction set portion with one or more components of an instructionset portion stored in a knowledgebase. Comparison may also beimplemented by matching one or more components of the new instructionset portion with one or more components of the instruction set portionsfrom the knowledgebase, factoring in the weights for each of thecomponents of instruction set portions from the knowledgebase. As suchmatching some components of the instruction set portions from theknowledgebase may be more important than other components having smallerweight.

At step 3425, a determination is made that there is a substantialsimilarity between the new instruction set portion and instruction setportions in the knowledgebase such as the first instruction set portion.In one embodiment, during the comparison of the one or more componentsof the new instruction set portion and the one or more components of thefirst instruction set portion a perfect match may be found. In otherembodiments, AI DBMS may find a plurality of perfect matches with aplurality of instruction set portions stored in a knowledgebase. If thenumber of matches exceeds a threshold for maximum number of substantialsimilarity results, strictness level for determining a substantialsimilarity match may be modified to include an additional one or morecomponents of the new instruction set portion in order to narrow down orreduce the number of the perfect matching results. In some embodiments,if no perfect match is found, or if a number of matches is lower than athreshold for minimum amount of substantially matching results, thenstrictness level may be reduced to allow for finding a match that isimperfect. In some embodiments, a strictness level may be reduced toallow for a match for more important components of the one or morecomponents of the new instruction set portion to be matched with thecomponents of instruction set portions in the knowledgebase. The moreimportant components (i.e. words, etc.) of the one or more components ofthe new instruction set portion may be components including commandwords or keywords. For example, a substantial match may be found whenSQL keywords from the one or more components of the new instruction setportion match SQL keywords, and/or the order of such keywords, from oneor more components of instruction set portions in the knowledgebase,even if one or more variable names, data names or database names are notmatched. Substantial match may also be found when a strictness level isreduced to allow a match to have all but one of the one or morecomponents of the new instruction set portion matching an instructionset portion in the knowledgebase. Similarly, a substantial match may befound when a strictness level is reduced to allow a match to have allbut two of the one or more components of the new instruction set portionmatching an instruction set portion in the knowledgebase. Likewise, asubstantial match may be found when a strictness level is reduced toallow a match to have all but three of the one or more components of thenew instruction set portion matching an instruction set portion in theknowledgebase. The one, two, or three non-matched components of the newinstruction set portion may be components having smaller or smallestweight. For example, the non-matched components of the new instructionset portion may be variable names, database names or other components ofthe instruction set portion that may be less important than the commandsor keywords, for example, Determination of substantial similaritybetween the one or more components of the new instruction set portionand the first instruction set portion may include any one of, or anycombination of, substantial similarity determination techniques orembodiments discussed herein.

At step 3430, the second instruction set portion is displayed on themobile device as an option to be selected by a user. The secondinstruction set portion may be displayed in response to determining thatthe first instruction set portion may be the most substantial match withthe new instruction set portion and that the second instruction setportion immediately follows the first instruction set portion. In someembodiments, AI DBMS may select the second instruction set portion fordisplay on the mobile device responsive to the determination at step3425. In further embodiments, the second instruction set portion may bedisplayed along with one or more instruction set portions that mayimmediately follow the second instruction set portion.

At step 3435, the second instruction set portion is modified in responseto edits by the user, should the user decide to modify the secondinstruction set portion. In one example, the second instruction setportion may be modified to indicate the same column, as was indicated inpreviously used instruction set portions of the new instruction set. Inanother example, the second instruction set portion may be modified toindicate an appropriate value to be used in the new instruction set.

At step 3440, a portion of the new instruction set is assembled usingthe new instruction set portion and a different portion of the newinstruction set is assembled using the second instruction set portion orthe modified second instruction set portion. In some embodiments,assembling may include storing the new instruction set portion and thesecond instruction set portion or the modified second instruction setportion in a data structure such as an array, linked list, table, etc.comprising all known instruction set portions of the new instructionset. In other embodiments, assembling may include appending the newinstruction set portion and the second instruction set portion or themodified second instruction set portion to a string of characterscontaining the known instruction set portions of the new instructionset, Assembling may include any action or operation by or for anAssociative Control Unit 1900.

At step 3445, steps 3415-3440 are repeated for all subsequent portionsof the new instruction set until the new instruction set's completion.Once all the needed instruction set portions are known the instructionset may be complete. In embodiments where the intermediary datastructure (i.e. array, linked list, table, etc.) is used for storingknown instruction set portions as previously described, the newinstruction set may be assembled from the instruction set portions inthe data structure before being sent to DBMS for execution. Assemblingmay include any action or operation by or for a Command Assembler 560,In embodiments where appending is performed of known instruction setportions as previously described, the new instruction set may bedirectly sent to DBMS for execution.

At step 3450, the operation defined by the new instruction set isperformed on the database. The operation performed may include one of,or a combination of: accessing, modifying, creating or deleting adatabase. The operation performed may include one of, or a combinationof: accessing, modifying, creating or deleting a table of a database.The operation performed may include one of, or a combination of:accessing, modifying, creating or deleting of a row, column, or cellwithin a table of a database. The operation performed may include oneof, or a combination of: accessing, modifying, creating or deleting areport/view, relation, user account, and/or other objects in a DBMS. Theoperation performed may include any DBMS operation described herein.

Referring to FIG. 34C, an embodiment of a method 7400 for implementingthe functionality of an AI DBMS via an interface is illustrated. Inbrief overview, at step 7405 a first instruction set for performing anoperation on a database is received. At step 7410, the first instructionset is processed into instruction set portions. At step 7415,instruction set portions are stored into a knowledgebase that comprisesplurality of other instruction sets, each having their own instructionset portions. At step 7420, one or more portions of a new instructionset that is entered by a user is received, the new instruction set forperforming an operation on a database. At step 7425, the one or moreportions of the new instruction set are compared with the portions ofthe plurality of instruction sets stored in the knowledgebase. At step7430, AI DBMS determines that there is a substantial similarity betweenthe one or more portions of the new instruction set and the firstinstruction set stored in the knowledgebase. At step 7435, the firstinstruction set is displayed on the mobile device as an option to beselected by the user. At step 7440, the interface provides the means forthe user to further modify the selected first instruction set, shouldthe user decide to do so. At step 7445, the operation defined by thefirst instruction set (or the modified instruction set) is performed onthe database.

In further detail, at step 7405 an interface for the AI DBMS receives afirst instruction set for performing an operation on a database. Thefirst instruction set may include commands and instructions, along withdata names and variable names identifying the specific operation to betaken on a specific database. The first instruction set may be receivedby the interface for a DBMS. The first instruction set may be receivedby any component of the AI DBMS.

At step 7410, the first instruction set is processed into instructionset portions. In some embodiment, the first instruction set isdisassembled into a plurality of portions. Each of the portions may befurther processed. Processing may also include identifying the type ofthe first instruction set, in terms of the commands used. Specificallydeterminations may be made to identify if the first instruction set isfor modifying data, selecting data, accessing data, creating a database,creating a row or a column within a database, making a new entry orsimilar nature or type of the first instruction set. Processing mayfurther include creating a timestamp of the time when the firstinstruction set has been received. Processing may further includeidentifying a user which entered the first instruction set oridentifying a group to which the user belongs. Processing may includeassigning a weight to each of the portions of the first instruction set,Processing may include any action or operation by or for a CommandDisassembler 500.

At step 7415, instruction set, along with its disassembled instructionset portions, may be stored in a knowledgebase that comprises aplurality of instruction sets, each of which includes a plurality ofportions of its own. In some embodiments, instruction sets may be storedin a data structure for storing instruction sets, such as a table of theknowledgebase. Instruction set portions may be stored in knowledgecells, where each group of instruction sets forms a knowledge cell.Knowledgebase or additional knowledgebases may also be populated toinclude the user specific and/or group specific informations gatheredwith respect to the first instruction set. Also stored in knowledgebasemay be the weight assigned to each of the portions of the firstinstruction set.

At step 7420, one or more portions of a new instruction set entered by auser on the mobile device is received. The one or more portions of thenew instruction set may be for performing some operation on somedatabase managed by the AI DBMS. In some embodiments, the user enters insequence one, two or three portions of a new instruction set which theuser intends to enter into the mobile device to perform an operationdefined by that new instruction set on a particular data in a database.As the user enters the one or more portions of the new instruction set,and before the user completes entering the entire new instruction set,the one or more portions of the new instruction set may be received by acomponent of the AI DBMS, such as the Associative SDCL ArtificialIntelligence 2800 or DBMS Artificial Intelligence 130. One or moreportions of the new instruction set may be stored into operations lists.

At step 7425, the received one or more portions of the new instructionset are compared with the portions of the instruction sets in theknowledgebase. The one or more portions of the new instruction set maybe compared with any of the portions of the instruction sets in theknowledgebase. In one embodiment, the one or more portions of the newinstruction set are compared as a single string of characters with aplurality of portions of instruction sets in the knowledgebase. In otherembodiments, comparison may be implemented by treating each instructionset portion as a separate string to be matched independently. In furtherembodiments, comparison is implemented by matching all of one or moreportions of the new instruction set with one or more portions of aninstruction set stored in a knowledgebase. Comparison may be implementedby matching all but one of the one or more portions of the newinstruction set with one or more portions of an instruction set storedin a knowledgebase. Comparison may also be implemented by matching allbut two of one or more portions of the new instruction set with one ormore portions of an instruction set stored in a knowledgebase.Comparison may also be implemented by comparing the one or more portionsof the new instruction set with portions of the instruction sets fromthe knowledgebase, factoring in the weights for each of the instructionset portions from the knowledgebase. As such matching some portions ofthe instruction sets from the knowledgebase may be more important thanother portions having smaller weight.

At step 7430, AI DBMS determines that there is a substantial similaritybetween the one or more portions of the new instruction set and thefirst instruction set stored in the knowledgebase. In one embodiment,during the comparison of the one or more portions of the new instructionset and the portions of the first instruction seta perfect match may befound. In other embodiments, AI DBMS may find a plurality of perfectmatches with a plurality of stored instruction sets. If the number ofmatches exceeds a threshold for maximum number of substantial similarityresults, strictness level for determining a substantial match may bemodified to include an additional one or more portions of the newinstruction set in order to narrow down or reduce the number of theperfect matching results.

Still at 7430, in some embodiments, if no perfect match is found, or ifa number of matches is lower than a threshold for minimum amount ofsubstantially matching results, then strictness level may be reduced toallow for finding a match that is imperfect. In some embodiments, astrictness level may be reduced to allow for a match for more importantportions of the one or more portions of the new instruction set to bematched with the instruction sets in the knowledgebase. The moreimportant portions of the one or more portions of the new instructionset may be portions including command words or keywords. For example, asubstantial match may be found when SQL keywords from the one or moreportions of the new instruction set match SQL keywords, and the order ofsuch keywords, in one or more stored instruction sets in theknowledgebase, even if one or more variable names, data names ordatabase names are not matched. Substantial match may also be found whena strictness level is reduced to allow a match to have all but oneportion of the one or more portions of the new instruction set matchingan instruction set in the knowledgebase. Similarly, a substantial matchmay be found when a strictness level is reduced to allow a match to haveall but two portions of the one or more portions of the new instructionset matching an instruction set in the knowledgebase. Likewise, asubstantial match may be found when a strictness level is reduced toallow a match to have all but three portions of the one or more portionsof the new instruction set matching an instruction set in theknowledgebase. The one, two, or three non-matched portions of theinstruction set may be portions having smaller or smallest weight. Forexample, the non-matched portions of the instruction set may be variablenames, database names or other portions of the instruction set that maybe less important than the command keywords, for example. Determinationof substantial similarity between the one or more portions of the newinstruction set and the first instruction set may include any one of, orany combination of, substantial similarity determination techniques orembodiments discussed herein.

At step 7435, mobile device may display the first instruction set as anoption to be selected by a user. The first instruction set may bedisplayed in response to determining that the first instruction set isthe most substantial match with the one or more portions of the newinstruction set. In some embodiments, AI DBMS may select the firstinstruction set for display on the mobile device responsive to thedetermination at step 7430. In further embodiments, the firstinstruction set may be displayed along with one or more instruction setsthat are also identified as substantially similar or substantiallymatching the one or more portions of the new instruction set at step7430.

At step 7440, the first instruction set may be modified in response toedits by the user. If a user decides that the first instruction set isvery similar to the instruction set the user wanted to enter, aside fora few changes for example, the user may modify the first instructionset. In some embodiments, interface for the AI DBMS may provide themeans for the user to modify the first instruction set upon theselection of the first instruction set on the display of the mobiledevice by the user.

At step 7445, AI DBMS performs the operation defined by the firstinstruction set (or the modified first instruction set if the firstinstruction set has been modified at step 7440) on the DBMS. Theoperation performed may include one of, or a combination of: accessing,modifying, creating or deleting a database. The operation performed mayinclude one of, or a combination of: accessing, modifying, creating ordeleting a table of a database. The operation performed may include oneof, or a combination of: accessing, modifying, creating or deleting of arow, column, or cell within a table of a database. The operationperformed may include one of, or a combination of: accessing, modifying,creating or deleting a report/view, relation, user account, and/or otherobjects in a DBMS. The operation performed may include any DBMSoperation described herein.

Referring to FIG. 35, in some aspects, the teaching presented by thecurrent disclosure may be implemented in exemplary embodiments toprovide AI DBMS functionalities for a media player, Such embodiments mayinclude artificial intelligence (i.e. machine learning and/oranticipation functionalities, etc.) to learn the user's use of the mediaDBMS, store this “knowledge” in a knowledgebase, and anticipate theuser's future operating intentions to help the user in his/her use ofthe media player, Such embodiments may also include the associativemethod of constructing Operations 610 or Instruction Sets 600 via keyinput, the SDCL for associative construction of Operations 610 orInstruction Sets 600 via phrase input, speech recognition for voiceinput, and/or other methods, systems, elements, or features and theirembodiments as previously described.

AI DBMS may be used by the User 10 on a Media Player 3500, and the MediaPlayer 3500 may further include Core Program 110, DBMS Artificialintelligence 130, Input interface 140, Output interface 160, Display170, Memory 180, Physical Storage Medium 181, Associative DBMS CommandConstructor 190, Associative SDCL Constructor 2400, Speech Recognizer2700, Microphone 2710, Underlying Media DBMS 3510, Sound Interface 3520,Speaker 3530, and Media Player Controls 3540. Other additional elementsmay be included as needed, or some of the disclosed ones may beexcluded, or a combination thereof may be utilized in alternateembodiments.

Media Player 3500 may comprise any hardware, software or a combinationof hardware and software, and/or it may include functions and algorithmsfor playing media. Examples of Media Player 3500 include a music playersuch as an iPod, a video player such as a DVD player, a picture player,a television device, a media capable computer, a media capable cellularphone such as a Smartphone, a media capable tablet, and other mediaplayers.

In some embodiments, Underlying Media DBMS 3510 may comprise anyhardware, software or a combination of hardware and software, and/or itmay include functions and algorithms for storing, managing and/ormanipulating various types of media or references thereto. The media mayinclude music, video, pictures, and other media generally included indigital files. In one example, the media files or references thereto maybe stored as Rows 330 in a single Table 310 within a single Database300. In another example, the media files or references thereto may bestored as Rows 330 in multiple Tables 310 within multiple Databases 300based on the type of content the media files contain (i.e. tables forspecific authors and databases for specific genres of music or video,etc.), Columns 320 may be provided to include additional informationsuch as author, authorship date, copyright information, and otheradditional information pertinent to the media file. Underlying MediaDBMS 3510 may reside on the User's 10 Media Player 3500 or it may resideon a remote Computing Device 1310 accessible over a Network 1300, and ifon a remote Computing Device 1310, the Underlying Media DBMS 3510 may beavailable as a network service (i.e. music or video streaming service,etc.) as previously described. User 10 may access, manage and/ormanipulate the Underlying Media DBMS 3510 by using a control meansand/or an associated interface of the Media Player 3500, and/or by usingthe previously described associative methods of constructing Operations610 or Instruction Sets 600 via key, phrase, and/or voice inputs, or acombination thereof.

In one example, each time User 10 wishes to play a media file on theMedia Player 3500, User 10 may issue an operating instruction (i.e.Instruction Set 600 or Operation 610, etc.) to the Underlying Media DBMS3510 to retrieve the media file or a reference thereto to be played.Responsive to the User's 10 operating instruction to retrieve the mediafile or a reference thereto, Underlying Media DBMS 3510 may perform aSELECT type of Instruction Set 600 or Operation 610 (i.e. SELECT type ofSQL statement, or any other SELECT type of DBMS command, etc.). Inanother example, each time User 10 wishes to delete a media file or areference thereto on the Media Player 3500, User 10 may issue anoperating instruction (i.e. Instruction Set 600 or Operation 610, etc.)to the Underlying Media DBMS 3510 to delete the media file or areference thereto. Responsive to the User's 10 operating instruction todelete the media file or a reference thereto, Underlying Media DBMS 3510may perform a DELETE type of instruction Set 600 or Operation 610 (i.e.DELETE type of SQL statement, or any other DELETE type of DBMS command,etc.). Furthermore, AI DBMS may learn the User's 10 operatinginstructions such as the media file or a reference thereto retrieving ordeleting instructions, store them for future use, and anticipate them inthe future as previously described.

In some embodiments, Media Player 3500 may include the associativemethod of constructing Operations 610 or Instruction Sets 600 via keyinput as previously described. In one example, Keys 2110 of the MediaPlayer Controls 3540 or other input device may be associated withinstruction Set Portions 620 of an Instruction Set 600 or Operation 610for retrieving a media file to be played from the Underlying Media DBMS3510. As such, User 10 may initially be offered a Selection 2300 on theMedia Player's 3500 Display 170 to input a Key 2110 indicating that theUser 10 wishes to play a media file. The next Selection 2300 the User 10may be offered may be to input a Key 2110 indicating in which play list(i.e. table in a database) is the media file the User 10 wishes to play.The next Selection 2300 the User 10 may be offered may be to input a Key2110 indicating which specific media file (i.e. row in a table) the User10 wishes to play. AI DBMS may assemble Instruction Set 600 or Operation610 from the inputted Keys 2110 and their associated Instruction SetPortions 620 to facilitate the User's operating instructions on theUnderlying Media DBMS 3510 as previously described.

In other embodiments, Media Player 3500 may include the SDCL forassociative construction of Operations 610 or Instruction Sets 600 viaphrase or voice input as previously described. In one example, Phrases2610 (i.e. user preferred phrases, etc.) may be associated withInstruction Set Portions 620 of an Instruction Set 600 or Operation 610for retrieving a media file to be played from the Underlying Media DBMS3510, As such, User 10 may initially be offered a Selection 2300 on theMedia Player's 3500 Display 170 to input a Phrase 2610 (i.e. “PLAY”,etc.) indicating that the User 10 wishes to play a media file. The nextSelection 2300 the User 10 may be offered may be to input a Phrase 2610(i.e. “MY FAVORITE LIST”, etc.) indicating in which play list (i.e.table in a database) is the media file the User 10 wishes to play. Thenext Selection 2300 the User 10 may be offered may be to input a Phrase2610 (i.e. “LOVE SONG”, etc.) indicating which specific media file (i.e.row in a table) the User 10 wishes to play. AI DBMS may assembleInstruction Set 600 or Operation 610 from the inputted Phrases 2610 andtheir associated Instruction Set Portions 620 to facilitate the User'soperating instructions on the Underlying Media DBMS 3510 as previouslydescribed.

In one exemplary embodiment, Media Player 3500 may be a music playersuch as an iPod. Underlying Media DBMS 3510 may include music files orreferences to music files with either or both the Underlying Media DBMS3510 and the music files stored in the Media Player's 3500 Memory 180and/or Physical Storage Medium 181. As the User 10 selects music filesto play, DBMS Artificial Intelligence 130 may learn the User's 10 musicplaying selections (i.e. Instruction Sets 600 or Operations 610); storethis “knowledge” (i.e. Knowledge Cells, etc.) in the Knowledgebase 530;and anticipate the User's 10 future music playing intentions (i.e.future/anticipatory Instruction Sets 600 or Operations 610) aspreviously described. User 10 may input his/her music playinginstructions (1) by using the music player's native control means suchas iPods control wheel and the associated control program (i.e.interface; etc.) that interprets the control wheel's input events andgenerates requests to access, manage, and/or manipulate the UnderlyingMedia DBMS 3510, and/or (2) by using the previously describedassociative methods of constructing instruction Sets 600 or Operations610 via key, phrase, and voice inputs, or a combination thereof.

In another exemplary embodiment, Media Player 3500 may be a networkconnected television device with network browsing capabilities.Underlying Media DBMS 3510 may include video files or references tovideo files with either or both the Underlying Media DBMS 3510 and thevideo files stored or on a remote Computing Device 1310 accessible overa Network 1300 as a network service. As the User 10 selects video filesto play, DBMS Artificial Intelligence 130 may learn the User's 10 videoplaying selections (i.e. Instruction Sets 600 or Operations 610); storethis “knowledge” (i.e. Knowledge Cells, etc.) in the Knowledgebase 530;and anticipate the User's 10 future video playing intentions (i.e.future/anticipatory Instruction Sets 600 or Operations 610) aspreviously described. Additionally, as previously described, a globalKnowledgebase 530 including video playing “knowledge” (i.e. KnowledgeCells, etc.) of other users may be available to User 10 to guide his/herfuture video playing intentions. User 10 may input his/her video playinginstructions (1) by using the television device's native control meanssuch as a remote control and the associated control program (i.e.interface; etc.) that interprets the remote control's input events andgenerates requests to access, manage, and/or manipulate the UnderlyingMedia DBMS 3510, and/or (2) by using the previously describedassociative methods of constructing instruction Sets 600 or Operations610 via key, phrase, and voice inputs, or a combination thereof.

In yet another exemplary embodiment, Media Player 3500 may be a standardtelevision device without network browsing capabilities. UnderlyingMedia DBMS 3510 may include cable, satellite, on-the-air or other videochannels or references thereto. Underlying Media DBMS 3510 may alsoinclude information on the User's 10 preferred settings such as volume,color, contrast, brightness, and other settings for various types ofchannels and video content. As the User 10 selects video channels towatch, DBMS Artificial Intelligence 130 may learn the User's 10 channelwatching selections (i.e. Instruction Sets 600 or Operations 610), thetiming of the channel watching selections, and the User's 10 preferredsettings for the various types of channels and video content; store this“knowledge” (i.e. Knowledge Cells, etc) in the Knowledgebase 530; andanticipate the User's 10 future channel watching intentions (i.e.future/anticipatory instruction Sets 600 or Operations 610) aspreviously described. In one example, User 10 may watch specificchannels at specific times (as many television watchers do when theywatch daily or weekly scheduled shows) and AI DBMS may learn thechannels and the times (i.e. using the time stamp, etc.) andautomatically switch to these channels at their specific times, and ifthe User 10 is not at home, AI DBMS may trigger a recording process forlater recorded channel watching. In another example, while watchinghis/her favorite show, User 10 may switch to other channels duringcommercials in specific time intervals, and AI DBMS may learn thechannels and the time intervals (Le, using time stamp, etc.) andautomatically switch the channels to avoid commercials. In yet anotherexample, User 10 may change volume, color, contrast, brightness, andother settings based on the User's 10 preferences for various types ofchannels and content, and AI DBMS may learn the User's 10 preferredsettings (i.e. using Extra Infos 630, etc.) for the specific channelsand content and adjust the settings automatically. User 10 may inputhis/her video playing instructions (1) by using the television device'snative control means such as a remote control and the associated controlprogram (i.e. interface, etc.) that interprets the remote control'sinput events and generates requests to access, manage, and/or manipulatethe Underlying Media DBMS 3510, and/or (2) by using the previouslydescribed associative methods of constructing Instruction Sets 600 orOperations 610 via key, phrase, and voice inputs, or a combinationthereof.

Sound Interface 3520 may comprise any hardware, software or acombination of hardware and software, and/or it may include functionsand algorithms for processing output from the Core Program 110 or otherelements of the current disclosure for listening by the User 10. SoundInterface 3520 falls under the general description of the previouslydescribed Output Interface 160, and it is described separately in thisembodiment to offer additional detail on its functioning. Soundinterface 3520 may be or include a sound driver, a Java sound API, abuilt-in sound interface, or any other sound interface.

Speaker 3530 may comprise any hardware, software or a combination ofhardware and software, and/or it may include functions and algorithmsfor providing sound to the User 10. Speaker 3530 may be a built-in or anexternal speaker, headphone, or any other sound producing device.

Media Player Controls 3540 may comprise any hardware, software or acombination of hardware and software, and/or it may include functionsand algorithms for inputting operating instructions or data. MediaPlayer Controls 3540 may include a means of inputting operatinginstructions or data by pressing keys or buttons, touching keys orbuttons, clicking keys or buttons, sliding physical components, ormanipulating other physical or other elements. Examples of Media PlayerControls 3540 include a control wheel (i.e. iPod's control wheel, etc.),a keypad, a touch screen, a keyboard, or any other input or controldevice.

Referring to FIG. 36, in some aspects, the teaching presented by thecurrent disclosure may be implemented in exemplary embodiments toprovide AI DBMS functionalities for a GPS receiver. Such embodiments mayinclude artificial intelligence (i.e. machine learning and/oranticipation functionalities, etc.) to learn the user's use of theglobal locations DBMS, store this “knowledge” in a knowledgebase, andanticipate the user's future operating intentions to help the user inhis/her use of the GPS receiver. Such embodiments may also include theassociative method of constructing Operations 610 or Instruction Sets600 via key input, the SDCL for associative construction of Operations610 or Instruction Sets 600 via phrase input, speech recognition forvoice input, and/or other methods, systems, elements, or features andtheir embodiments as previously described.

AI DBMS may be used by the User 10 on a GPS Receiver 3600, and the GPSReceiver 3600 may further include Core Program 110, DBMS Artificialintelligence 130, Input Interface 140, Output Interface 160, Display170, Memory 180, Physical Storage Medium 181, Associative DBMS CommandConstructor 190, Associative SDCL Constructor 2400, Speech Recognizer2700, Microphone 2710, Sound interface 3520, Speaker 3530, UnderlyingLocations DBMS 3610, and Touch Screen 3620. Other additional elementsmay be included as needed, or some of the disclosed ones may beexcluded, or a combination thereof may be utilized in alternateembodiments.

GPS Receiver 3600 may comprise any hardware, software or a combinationof hardware and software, and/or it may include functions and algorithmsfor GPS functionalities. Examples of the GPS Receiver 3600 include ahand-held GPS receiver, a built-in GPS receiver (i.e. built-in a car orboat, etc.), GPS capable cellular telephone (i.e. Smartphone, etc.), andother GPS receivers.

In some embodiments, Underlying Locations DBMS 3610 may comprise anyhardware, software or a combination of hardware and software, and/or itmay include functions and algorithms for storing, managing and/ormanipulating location references. Location references may includelatitude/longitude/altitude coordinates, street addresses, distancesfrom a fixed point, and other location references. In one example,location references may be stored as Rows 330 in a single Table 310within a single Database 300. In another example, location referencesmay be stored as Rows 330 in multiple Tables 310 within multipleDatabases 300 based on the geographic groupings (i.e. tables forspecific cities and databases for specific countries, etc.). Columns 320may be provided to include additional information such as population,historic facts, general climate facts, and other additional informationpertinent to a specific location reference. Underlying Locations DBMS3610 may reside on the User's 10 GPS Receiver 3600 or it may reside on aremote Computing Device 1310 accessible over a Network 1300, and if on aremote Computing Device 1310, the Underlying Locations DBMS 3610 may beavailable as a network service (i.e. service for updating locationreferences, etc.) as previously described. User 10 may access, manageand/or manipulate the Underlying Locations DBMS 3610 by using a controlmeans and/or an associated interface of the GPS Receiver 3600, and/or byusing the previously described associative methods of constructingOperations 610 or Instruction Sets 600 via key, phrase, and/or voiceinputs, or a combination thereof.

In one example, each time User 10 wishes to visit a location stored onthe GPS Receiver 3600, User 10 may issue an operating instruction (i.e.Instruction Set 600 or Operation 610, etc.) to the Underlying LocationsDBMS 3610 to retrieve the location reference (i.e.latitude/longitude/altitude coordinates, address, etc.) to be visited.Responsive to the User's 10 operating instruction to retrieve thelocation reference, Underlying Locations DBMS 3610 may perform a SELECTtype of Instruction Set 600 or Operation 610 (i.e. SELECT type of SQLstatement, or any other SELECT type of DBMS command, etc.). In anotherexample, each time User 10 wishes to delete a location reference on theGPS Receiver 3600, User 10 may issue an operating instruction (Le,Instruction Set 600 or Operation 610, etc.) to the Underlying LocationsDBMS 3610 to delete the location reference. Responsive to the User's 10operating instruction to delete the location reference, UnderlyingLocations DBMS 3610 may perform a DELETE type of Instruction Set 600 orOperation 610 (i.e. DELETE type of SQL statement, or any other DELETEtype of DBMS command, etc.). Furthermore, AI DBMS may learn the User's10 operating instructions such as the location reference retrieving ordeleting instructions, store them for future use, and anticipate them inthe future as previously described.

In some embodiments, GPS Receiver 3600 may include the associativemethod of constructing Operations 610 or Instruction Sets 600 via keyinput as previously described. For example, Keys 2110 of the TouchScreen 3620 or other input device may be associated with Instruction SetPortions 620 of an Instruction Set 600 or Operation 610 for retrieving alocation reference of a location to be visited from the UnderlyingLocations DBMS 3610. As such, User 10 may initially be offered aSelection 2300 on the GPS Receiver's 3600 Display 170 to input a Key2110 indicating that the User 10 wishes to visit a location. The nextSelection 2300 the User 10 may be offered may be to input a Key 2110indicating in which city (i.e. table in a database) is the location theUser 10 wishes to visit. The next Selection 2300 the User 10 may beoffered may be to input a Key 2110 indicating which specific location(i.e. row in a table) the User 10 wishes to visit. AI DBMS may assembleInstruction Set 600 or Operation 610 from the inputted Keys 2110 andtheir associated instruction Set Portions 620 to facilitate the User'soperating instructions on the Underlying Locations DBMS 3610 aspreviously described.

In other embodiments, GPS Receiver 3600 may include the SDCL forassociative construction of Operations 610 or instruction Sets 600 viaphrase or voice input as previously described. For example, Phrases 2610(i.e. user preferred phrases, etc.) may be associated with InstructionSet Portions 620 of an Instruction Set 600 or Operation 610 forretrieving a location reference of a location to be visited from theUnderlying Locations DBMS 3610. As such, User 10 may initially beoffered a Selection 2300 on the GPS Receiver's 3600 Display 170 to inputa Phrase 2610 (i.e. “GO TO”, etc.) indicating that the User 10 wishes tovisit a location. The next Selection 2300 the User 10 may be offered maybe to input a Phrase 2610 (i.e. “LOS ANGELES”, etc.) indicating in whichcity (i.e. table in a database) is the location the User 10 wishes tovisit. The next Selection 2300 the User 10 may be offered may be toinput a Phrase 2610 (Le, “SCIENCE MUSEUM”, etc.) indicating whichspecific location (i.e. row in a table) the User 10 wishes to visit. AIDBMS may assemble instruction Set 600 or Operation 610 from the inputtedPhrases 2610 and their associated instruction Set Portions 620 tofacilitate the User's operating instructions on the Underlying LocationsDBMS 3610 as previously described.

In one exemplary embodiment, GPS Receiver 3600 may be a networkconnected GPS receiver. Underlying Locations DBMS 3610 may includelocation references stored in the GPS Receiver's 3600 Memory 180 and/orPhysical Storage Medium 181. As the User 10 selects location referencesto visit, DBMS Artificial Intelligence 130 may learn the User's 10selections (i.e. Instruction Sets 600 or Operations 610) of locationreferences; store this “knowledge” (i.e. Knowledge Cells, etc.) in theKnowledgebase 530; and anticipate the User's 10 future location visitingintentions (i.e. future/anticipatory Instruction Sets 600 or Operations610) as previously described. Additionally, as previously described, aglobal Knowledgebase 530 including location visiting “knowledge” (i.e.Knowledge Cells, etc.) of other users may be available to User 10 toguide his/her future location visiting intentions. In one example, User10 may come to a city for the first time and look for places of interestto visit. After User 10 discovers and visits a great restaurant and/oran interesting museum, AI DBMS may anticipate the User's 10 futurelocation references based on the sequence of location visits of otherusers in the global Knowledgebase 530 who visited the same restaurantand/or the museum. User 10 may input his/her location visitinginstructions (1) by using GPS Receiver's 3600 native control means suchas the Touch Screen 3620 and the associated control program (i.e.interface, etc.) that interprets the touch screen's input events andgenerates requests to access, manage, and/or manipulate the UnderlyingLocations DBMS 3610, and/or (2) by using the previously describedassociative methods of constructing Instruction Sets 600 or Operations610 via key, phrase, and voice inputs, or a combination thereof.

Touch Screen 3620 may comprise any hardware, software or a combinationof hardware and software, and/or it may include functions and algorithmsfor inputting operating instructions or data, Touch Screen 3620 mayinclude a means of inputting operating instructions or data by touchingareas of the Touch Screen 3620 representing keys or buttons, slidingTouch Screen's 3620 slider components, or manipulating other TouchScreen 3620 elements.

Referring to FIG. 37, in some aspects, the teaching presented by thecurrent disclosure may be implemented in exemplary embodiments toprovide AI DBMS functionalities for a business operation. Suchembodiments may include artificial intelligence (i.e. machine learningand/or anticipation functionalities, etc.) to learn the user's use ofthe business operation DBMS, store this “knowledge” in a knowledgebase,and anticipate the user's future operating intentions to help the userin his/her running the business operation, Such embodiments may alsoinclude the associative method of constructing Operations 610 orInstruction Sets 600 via key input, the SDCL for associativeconstruction of Operations 610 or instruction Sets 600 via phrase input,speech recognition for voice input, and/or other methods, systems,elements, or features and their embodiments as previously described.

AI DBMS may be used by the User 10 on a Personal Computer 3700, and thePersonal Computer 3700 may further include Core Program 110, DBMSArtificial Intelligence 130, Input Interface 140, Keyboard 150, OutputInterface 160, Display 170, Memory 180, Physical Storage Medium 181,Associative DBMS Command Constructor 190, Associative SDCL Constructor2400, Speech Recognizer 2700, Microphone 2710, Sound interface 3520,Speaker 3530, and Underlying Business Operation DBMS 3710. Otheradditional elements may be included as needed, or some of the disclosedones may be excluded, or a combination thereof may be utilized inalternate embodiments.

Personal Computer 3700 may comprise any hardware, software or acombination of hardware and software, and/or it may include functionsand algorithms for computing functionalities. Examples of the PersonalComputer 3700 include a desktop computer, a mobile computer such as alaptop or tablet computer, computing capable cellular telephone (i.e.Smartphone, etc.), and other personal computers.

In some embodiments, Underlying Business Operation DBMS 3710 maycomprise any hardware, software or a combination of hardware andsoftware, and/or it may include functions and algorithms for storing,managing and/or manipulating various business operation data. Businessoperation data may include sales, inventory, payroll, employee benefits,financial, and other business operation data. In a small businessexample, business operation data may be stored as Rows 330 in a singleor multiple Tables 310 within a single Database 300. In an enterpriseorganization example, business operation data may be stored as Rows 330in multiple Tables 310 within multiple Databases 300 based on theorganizational departments (i.e. tables for specific functions within adepartment and databases for specific departments, etc.). UnderlyingBusiness Operation DBMS 3710 may reside on the User's 10 PersonalComputer 3700 or it may reside on a remote Computing Device 1310accessible over a Network 1300, and if on a remote Computing Device1310, the Underlying Business Operation DBMS 3710 may be available as anetwork service (i.e. database service for multiple users to connect anduse, etc.) as previously described. User 10 may access, manage and/ormanipulate the Underlying Business Operation DBMS 3710 by using acontrol means and/or an associated interface of the Personal Computer3700, and/or by using the previously described associative methods ofconstructing Operations 610 or instruction Sets 600 via key, phrase,and/or voice inputs, or a combination thereof.

In one example, each time User 10 wishes to view a business operationdata on the Personal Computer 3700, User 10 may issue an operatinginstruction (i.e. instruction Set 600 or Operation 610, etc.) to theUnderlying Business Operation DBMS 3710 to retrieve the businessoperation data to be viewed. Responsive to the User's 10 operatinginstruction to retrieve the business operation data, Underlying BusinessOperation DBMS 3710 may perform a SELECT type of Instruction Set 600 orOperation 610 (Le, SELECT type of SQL statement, or any other SELECTtype of DBMS command, etc.). In another example, each time User 10wishes to delete a business operation data on the Personal Computer3700, User 10 may issue an operating instruction (i.e. Instruction Set600 or Operation 610, etc.) to the Underlying Business Operation DBMS3710 to delete the business operation data. Responsive to the User's 10operating instruction to delete the business operation data, UnderlyingBusiness Operation DBMS 3710 may perform a DELETE type of InstructionSet 600 or Operation 610 (i.e. DELETE type of SQL statement, or anyother DELETE type of DBMS command, etc.). Furthermore, AI DBMS may learnthe User's 10 operating instructions such as the business operation dataretrieving or deleting instructions, store them for future use, andanticipate them in the future as previously described.

In some embodiments, Personal Computer 3700 may include the associativemethod of constructing Operations 610 or instruction Sets 600 via keyinput as previously described. In one example, Keys 2110 of the Keyboard150 or other input device may be associated with instruction SetPortions 620 of an instruction Set 600 or Operation 610 for retrieving abusiness operation data to be viewed from the Underlying BusinessOperation DBMS 3710. As such, User 10 may initially be offered aSelection 2300 on the Personal Computer's 3700 Display 170 to input aKey 2110 indicating that the User 10 wishes to view a business operationdata. The next Selection 2300 the User 10 may be offered may be to inputa Key 2110 indicating in which table (i.e. table in a database) is thebusiness operation data the User 10 wishes to view. The next Selection2300 the User 10 may be offered may be to input a Key 2110 indicatingwhich specific business operation data (i.e. row in a table) the User 10wishes to view. AI DBMS may assemble Instruction Set 600 or Operation610 from the inputted Keys 2110 and their associated Instruction SetPortions 620 to facilitate the User's operating instructions on theUnderlying Business Operation DBMS 3710 as previously described.

In other embodiments, Personal Computer 3700 may include the SDCL forassociative construction of Operations 610 or instruction Sets 600 viaphrase or voice input as previously described. In one example, Phrases2610 (i.e. user preferred phrases, etc.) may be associated withInstruction Set Portions 620 of an Instruction Set 600 or Operation 610for retrieving a business operation data to be viewed from theUnderlying Business Operation DBMS 3710. As such; User 10 may initiallybe offered a Selection 2300 on the Personal Computer's 3700 Display 170to input a Phrase 2610 (i.e. “GET DATA”, etc.) indicating that the User10 wishes to view a business operation data. The next Selection 2300 theUser 10 may be offered may be to input a Phrase 2610 (i.e. “SALES”,etc.) indicating in which table (i.e. table in a database) is thebusiness operation data the User 10 wishes to view. The next Selection2300 the User 10 may be offered may be to input a Phrase 2610 (i.e.“2013 FORD FOCUS”, etc.) indicating which specific business operationdata (i.e. row in a table) the User 10 wishes to view. AI DBMS mayassemble Instruction Set 600 or Operation 610 from the inputted Phrases2610 and their associated instruction Set Portions 620 to facilitate theUser's operating instructions on the Underlying Business Operation DBMS3710 as previously described.

In one exemplary embodiment, Personal Computer 3700 may be a networkconnected desktop computer. Underlying Business Operation DBMS 3710 mayreside on a remote Computing Device 1310 accessible over a Network 1300(i.e. enterprise network, or virtual private network over the Internet,etc.). As the User 10 performs select, insert, update, delete and otheroperations on the business operation data, DBMS Artificial intelligence130 may learn User's 10 operations (i.e. Instruction Sets 600 orOperations 610); store this “knowledge” (i.e. Knowledge Cells, etc.) inthe Knowledgebase 530; and anticipate the User's 10 future operatingintentions (i.e. future/anticipatory Instruction Sets 600 or Operations610) as previously described. In one example, User 10 may be responsiblefor maintaining sales and inventory Tables 310 within one or multipleDatabases 300. When a sale is made, User 10 may need to perform severalinsert, update, and/or other operations such as inserting a Row 330 intothe sales Table 310 and updating a Row 330 in the inventory Table 310for each product sold. Each product may have its separate sales andinventory Tables 310 and User 10 may need to perform update operationson multiple sales and inventory Tables 310. After performing insert andupdate operations for one or more initial sale transactions, AI DBMS maylearn the User's 10 sequence of operations for each sale transaction andperform the corresponding operations automatically. In another example,User 10 may be responsible for financial reporting. This type ofreporting is often a daily, weekly, monthly and/or yearly scheduledprocess of creating same or similar reports with updated times, dates orother filtering information. After creating one or more scheduledReports/Views 350, AI DBMS may learn the timing (i.e. using time stamp,etc.) of the User's 10 Reports/Views 350 creation and create futureReports/Views 350 automatically, User 10 may input his/her businessoperation DBMS instructions (1) by using the previously describedKeyboard 150 and Input Interface 140 to access, manage and/or manipulatethe Underlying Business Operation DBMS 3710, and/or (2) by using thepreviously described associative methods of constructing InstructionSets 600 or Operations 610 via key, phrase, and voice inputs, or acombination thereof.

In another exemplary embodiment, Personal Computer 3700 may be a networkconnected mobile computer. Underlying Business Operation DBMS 3710 maybe stored in the Personal Computer's 3700 Memory 180 or Physical StorageMedium 181. Also, User 10 may be a non-technical small business userattempting to create a Database 300 with several business operationTables 310 (i.e. sales, inventory, etc.). As previously described, aglobal Knowledgebase 530 including Database 300 and Table 310 creation“knowledge” (i.e. Knowledge Cells, etc.) of other users may be availableto User 10 to guide his/her Database 300 and Table 310 creationintentions. In one example, User 10 may be a professional painter andwish to create a database for a business that sells paintings. User 10may wish to organize his/her paintings for sale into several Tables 310based on the topic of the paintings (i.e. a Table 310 for paintings ofnature, a Table 310 for paintings of animals, etc.). After User 10creates an initial empty Database 300 titled “paintings for sale,” AIDBMS may anticipate the user's table creation intentions (i.e.future/anticipatory Instruction Sets 600 or Operations 610) based on thesequence of table creations of other users in the global Knowledgebase530 who created a “paintings for sale” (or its semantic variations)Database 300 in a similar small business context. User 10 may inputhis/her business operation DBMS instructions (1) by using the previouslydescribed Keyboard 150 and input Interface 140 to access, manage and/ormanipulate the Underlying Business Operation DBMS 3710, and/or (2) byusing the previously described associative methods of constructingInstruction Sets 600 or Operations 610 via key, phrase, and voiceinputs, or a combination thereof.

A number of embodiments have been described herein. While thisspecification contains many specific implementation details, theseshould not be construed as limitations on the scope of any inventions orof what may be claimed, but rather as descriptions of features specificto particular embodiments. It will be understood that variousmodifications may be made without departing from the spirit and scope ofthe invention. The logic flows depicted in the figures do not requirethe particular order shown, or sequential order, to achieve desirableresults. In addition, other or additional steps may be provided, or someof the steps may be eliminated, from the described flows, and/or othercomponents may be added to, or removed from, the described methods,systems and techniques. Further, the various aspects and disclosedmethods, systems and techniques can be combined in whole or in part witheach other to produce additional implementations. Moreover, theseparation of various components in the embodiments described hereinshould not be understood as requiring such separation in allembodiments, and it should be understood that the described componentsmay generally be integrated together in a single software product orpackaged into multiple software products. Accordingly, other embodimentsare within the scope of the following claims.

1. A system for associative anticipatory construction of an instructionset, the system implemented on one or more computing devices, the systemcomprising: one or more processor circuits; one or more memory units,coupled to the one or more processor circuits, configured to store aplurality of collections of user preferred phrases each user preferredphrase associated with an instruction set element, the plurality ofcollections including a first collection, wherein the instruction setelements associated with the user preferred phrases of the firstcollection include instruction set elements from which an instructionset element can be chosen to assemble a first portion of a newinstruction set for performing an operation on a database managementsystem; a sound capturing device, coupled to the one or more processorcircuits; and a display, coupled to the one or more processor circuits,wherein the one or more processor circuits are configured to: cause thedisplay to display the user preferred phrases of the first collection;receive a user's sound from the sound capturing device; recognize a userpreferred phrase of the first collection from the user's sound; andassemble the first portion of the new instruction set using aninstruction set element associated with the recognized user preferredphrase of the first collection.
 2. The system of claim 1, wherein theone or more memory units are further configured to store a plurality ofportions of anticipatory instruction sets for performing operations onthe database management system, and wherein the one or more processorcircuits are further configured to: anticipate one or more remainingportions of the new instruction set based on at least a partial matchbetween the first portion of the new instruction set and a first portionof an anticipatory instruction set of the plurality of portions ofanticipatory instruction sets; cause the display to display the one ormore anticipated remaining portions of the new instruction set; receive,from an input device coupled to the one or more processor circuits, auser's selection of one or more anticipated remaining portions of thenew instruction set; and assemble less than the entire new instructionset using the first portion of the new instruction set and the selectedone or more anticipated remaining portions of the new instruction set.3. The system of claim 1, wherein the one or more memory units arefurther configured to store a plurality of portions of anticipatoryinstruction sets for performing operations on the database managementsystem, and wherein the one or more processor circuits are furtherconfigured to: anticipate one or more remaining portions of the newinstruction set based on at least a partial match between the firstportion of the new instruction set and a first portion of ananticipatory instruction set of the plurality of portions ofanticipatory instruction sets; cause the display to display the one ormore anticipated remaining portions of the new instruction set; receive,from an input device coupled to the one or more processor circuits, auser's selection of one or more anticipated remaining portions of thenew instruction set; and assemble the new instruction set using thefirst portion of the new instruction set and the selected one or moreanticipated remaining portions of the new instruction set.
 4. The systemof claim 1, wherein the one or more memory units are further configuredto store a plurality of anticipatory instruction sets for performingoperations on the database management system, and wherein the one ormore processor circuits are further configured to: anticipate the newinstruction set based on at least a partial match between the firstportion of the new instruction set and a first portion of ananticipatory instruction set of the plurality of anticipatoryinstruction sets; cause the display to display the anticipated newinstruction set; and receive, from an input device coupled to the one ormore processor circuits, a user's selection of the anticipated newinstruction set.
 5. The system of claim 1, wherein the one or morememory units are further configured to store a plurality of anticipatoryinstruction sets for performing operations on the database managementsystem, and wherein the one or more processor circuits are furtherconfigured to: anticipate the new instruction set based on at least apartial match between the first portion of the new instruction set and afirst portion of an anticipatory instruction set of the plurality ofanticipatory instruction sets; and select the anticipated newinstruction set without user input.
 6. The system of claim 1, whereinthe new instruction set includes a structured query language (SQL) or aprogramming language.
 7. The system of claim 1, wherein the databasemanagement system includes an Oracle, a Microsoft SQL Server, a MySQL,an Informix, a Sybase, or a relational database management system. 8.The system of claim 1, wherein the database management system includesone or more databases, one or more tables, or one or more datastructures.
 9. The system of claim 1, wherein the database managementsystem includes one or more files, one or more file systems, or one ormore electronic repositories.
 10. The system of claim 1, wherein the oneor more processor circuits, the one or more memory units, the display,and the sound capturing device of the system are included in a singledevice.
 11. A non-transitory computer storage medium having a computerprogram stored thereon, the program comprising instructions that whenexecuted by one or more processor circuits cause the one or moreprocessor circuits to perform operations comprising: accessing one ormore memory units configured to store a plurality of collections of userpreferred phrases each user preferred phrase associated with aninstruction set element, the plurality of collections including a firstcollection, wherein the instruction set elements associated with theuser preferred phrases of the first collection include instruction setelements from which an instruction set element can be chosen to assemblea first portion of a new instruction set for performing an operation ona database management system; causing a display to display the userpreferred phrases of the first collection; receiving a user's sound froma sound capturing device; recognizing a user preferred phrase of thefirst collection from the user's sound; and assembling the first portionof the new instruction set using an instruction set element associatedwith the recognized user preferred phrase of the first collection. 12.The non-transitory computer storage medium of claim 11, wherein the oneor more memory units are further configured to store a plurality ofportions of anticipatory instruction sets for performing operations onthe database management system, and wherein the one or more processorcircuits' operations further comprising: anticipating one or moreremaining portions of the new instruction set based on at least apartial match between the first portion of the new instruction set and afirst portion of an anticipatory instruction set of the plurality ofportions of anticipatory instruction sets; causing the display todisplay the one or more anticipated remaining portions of the newinstruction set; receiving, from an input device, a user's selection ofone or more anticipated remaining portions of the new instruction set;and assembling less than the entire new instruction set using the firstportion of the new instruction set and the selected one or moreanticipated remaining portions of the new instruction set.
 13. The nontransitory computer storage medium of claim 11, wherein the one or morememory units are further configured to store a plurality of portions ofanticipatory instruction sets for performing operations on the databasemanagement system, and wherein the one or more processor circuits'operations further comprising: anticipating one or more remainingportions of the new instruction set based on at least a partial matchbetween the first portion of the new instruction set and a first portionof an anticipatory instruction set of the plurality of portions ofanticipatory instruction sets; causing the display to display the one ormore anticipated remaining portions of the new instruction set;receiving, from an input device, a user's selection of one or moreanticipated remaining portions of the new instruction set; andassembling the new instruction set using the first portion of the newinstruction set and the selected one or more anticipated remainingportions of the new instruction set.
 14. The non-transitory computerstorage medium of claim 11, wherein the one or more memory units arefurther configured to store a plurality of anticipatory instruction setsfor performing operations on the database management system, and whereinthe one or more processor circuits' operations further comprising:anticipating the new instruction set based on at least a partial matchbetween the first portion of the new instruction set and a first portionof an anticipatory instruction set of the plurality of anticipatoryinstruction sets; causing the display to display the anticipated newinstruction set; and receiving, from an input device, a user's selectionof the anticipated new instruction set.
 15. The non-transitory computerstorage medium of claim 11, wherein the one or more memory units arefurther configured to store a plurality of anticipatory instruction setsfor performing operations on the database management system, and whereinthe one or more processor circuits' operations further comprising:anticipating the new instruction set based on at least a partial matchbetween the first portion of the new instruction set and a first portionof an anticipatory instruction set of the plurality of anticipatoryinstruction sets; and selecting the anticipated new instruction setwithout user input.
 16. A method comprising: (a) accessing one or morememory units configured to store a plurality of collections of userpreferred phrases each user preferred phrase associated with aninstruction set element, the plurality of collections including a firstcollection, wherein the instruction set elements associated with theuser preferred phrases of the first collection include instruction setelements from which an instruction set element can be chosen to assemblea first portion of a new instruction set for performing an operation ona database management system, the accessing of (a) performed by one ormore processor circuits; (b) displaying on a display the user preferredphrases of the first collection, the displaying of (b) caused by the oneor more processor circuits; (c) receiving, by the one or more processorcircuits from a sound capturing device, a user's sound; (d) recognizinga user preferred phrase of the first collection from the user's sound,the recognizing of (d) performed by the one or more processor circuits;and (e) assembling the first portion of the new instruction set using aninstruction set element associated with the recognized user preferredphrase of the first collection, the assembling of (e) performed by theone or more processor circuits.
 17. The method of claim 16, wherein theone or more memory units are further configured to store a plurality ofportions of anticipatory instruction sets for performing operations onthe database management system, and wherein the method furthercomprising: (f) anticipating one or more remaining portions of the newinstruction set based on at least a partial match between the firstportion of the new instruction set and a first portion of ananticipatory instruction set of the plurality of portions ofanticipatory instruction sets, the anticipating of (f) performed by theone or more processor circuits; (g) displaying on the display the one ormore anticipated remaining portions of the new instruction set, thedisplaying of (g) caused by the one or more processor circuits; (h)receiving, by the one or more processor circuits from an input device, auser's selection of one or more anticipated remaining portions of thenew instruction set; and (i) assembling less than the entire newinstruction set using the first portion of the new instruction set andthe selected one or more anticipated remaining portions of the newinstruction set, the assembling of (i) performed by the one or moreprocessor circuits.
 18. The method of claim 16, wherein the one or morememory units are further configured to store a plurality of portions ofanticipatory instruction sets for performing operations on the databasemanagement system, and wherein the method further comprising: (f)anticipating one or more remaining portions of the new instruction setbased on at least a partial match between the first, portion of the newinstruction set and a first portion of an anticipatory instruction setof the plurality of portions of anticipatory instruction sets, theanticipating of (f) performed by the one or more processor circuits; (g)displaying on the display the one or more anticipated remaining portionsof the new instruction set, the displaying of (g) caused by the one ormore processor circuits; (h) receiving, by the one or more processorcircuits from an input device, a user's selection of one or moreanticipated remaining portions of the new instruction set; and (i)assembling the new instruction set using the first portion of the newinstruction set and the selected one or more anticipated remainingportions of the new instruction set, the assembling of (i) performed bythe one or, more processor circuits.
 19. The method of claim 16, whereinthe one or more memory units are further configured to store a pluralityof anticipatory instruction sets for performing operations on thedatabase management system, and wherein the method further comprising:(f) anticipating the new instruction set based on at least a partialmatch between the first portion of the new instruction set and a firstportion of an anticipatory instruction set of the plurality ofanticipatory instruction sets, the anticipating of (f) performed by theone or more processor circuits; (g) displaying on the display theanticipated new instruction set, the displaying of (g) caused by the oneor more processor circuits; and (h) receiving, by the one or moreprocessor circuits from an input device, a user's selection of theanticipated new instruction set.
 20. The method of claim 16, wherein theone or more memory units are further configured to store a plurality ofanticipatory instruction sets for performing operations on the databasemanagement system, and wherein the method further comprising: (f)anticipating the new instruction set based on at least a partial matchbetween the first portion of the new instruction set and a first portionof an anticipatory instruction set of the plurality of anticipatoryinstruction sets, the anticipating of (f) performed by the one or moreprocessor circuits; and (g) selecting the anticipated new instructionset without user input, the selecting of (g) performed by the one ormore processor circuits.